Dot Net Tips and Tricks

An interesting feature of SQL Server 2008 is the ability to pass tables as a parameter around in stored procedures. I know myself, I’ve found many times where I need to execute a stored procedure from another stored procedure and want to get the result back and then join against it in another stored procedure. An article over at www.SQLservercentral.com details this new feature.

Essentially you define a user type of type table then setup a parameter as table on the new stored procedure. Very straightforward.

Link to the article here

I use the Database Engine Tuning Wizard to analyze queries for performance. If you get the dreaded CRT error:

Microsoft has posted a nice knowledge base article on how to correct the problem here.