SanDroid (12/20/2010)
WayneS (12/20/2010)
6. Table variables are the only available choice to pass a table to a procedure.I know XML is not realy a table, but it can be used to pass a table to a procedure as an input parameter. :w00t:
Yep, prior to being able to pass a table to a procedure, one was limited to using XML or delimited strings. I haven't actually played with passing a table yet, but it does look really promising!
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes