Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
2008 - User Defined Type - Table
0 views
Skip to first unread message
adag617
Dec 18, 2009, 3:52:08 PM12/18/09
to
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.
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.
Erland Sommarskog
Dec 18, 2009, 5:18:19 PM12/18/09
to
table types in a single procedure, I see no point in defining table
types.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.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/prodinfo/previousversions/books.mspx
0 new messages