I have an SP with a bunch of table variables used extensively
throughout. Is there any reason to declare these as User Defined
Table Type (new in 2008). I'm not passing these variables outside of
of the procedure presently but curious if there is any performance
benefit.

adag617 (andrew.dagostino (AT) wbmason (DOT) com) writes:
I see no reason to expect a performance benefit. If you only uses
table types in a single procedure, I see no point in defining table
types.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx