Quoted: Some nifty SQL statements I made last week: Firstly, listing all databases on a server. -- Get Databases SELECT name FROM master.dbo.sysdatabases ORDER BY name Secondly, a way to get all the user-created stored procedures from a database. -- Get Stored

good explanation of @@IDENTITY vs SCOPE_IDENTITY()... I never knew the difference. Also, there are 9 other things you should watch out for. (lots of common sense)

Quoted: Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value (primary key) that was entered by your active session, but in different scenarios they can each ...

Looks nice for Data Dictionary searches...

Quoted: The following lengthy SQL script will create a system function in SQL Server that returns a data dictionary for any database on the server

nice little stored procedure to find columns by name in a schema.

Quoted: Here is a short stored procedure that you can use to find: * a table by its full name * a table by partial name ...

A blog with SQL Server tips. This is especially useful since SQL Server 2005 is emerging onto the field of play... with major differences from SQL Server 2000.

Not just with SQL Server. These functions work in Access too.

Unfortunately, using functions like there often times don't work over an ODBC connection (depending on your driver). It is oft tempting to use the database to do the date calculations... but you'll have better flexibility if you do your calculations in your application logic.

Regardless... these functions are definitely useful.