[thelist] Laptop - Web Design Wishlist
Paul Bennett
paul at teltest.com
Wed Sep 17 20:23:03 CDT 2003
Tim Burgan wrote:
>
>What would be people's DREAM setup though.
>
a 2.5GHz pda/phone with 19" projection screen, wireless DSL, and a link
right into my head so I don't have to type
ok, ok tip owed...
<tip type="sql server - listing all databases">
If you ever need to list the databases in SQL Server (7.0 and 2000 I
think) use this query:
"select CATALOG_NAME from INFORMATION_SCHEMA.SCHEMATA"
running the query results through a loop will give you a nice db list
</tip>
>
>
>
--
------------------------------
Paul Bennett
Internet Developer
Teltest Electronic Design
------------------------------
Email: paul at teltest.com
Phone: 64 4 237 4557
Web: http://www.teltest.com
Wap: http://wap.teltest.com
More information about the thelist
mailing list