Browse by Tags

All Tags » undocumented (RSS)

Simulating undocumented Procedures

Sometimes you may want to run a query against each database Suppose you want to find all dabase names where particular table exists. You can use undocumented procedure EXEC sp_msforeachdb 'SELECT table_catalog FROM ?.INFORMATION_SCHEMA.TABLES where...

Undocumented DATE and TIME related functions

It is quite surprising to know the undocumented date and time related functions that work in both sql server 2000 and 2005 Run these and see(I think they are self-explanatory ) select {fn current_date()} select {fn current_time()} select {fn now()} select...
Posted by Madhivanan | with no comments