question

Parthasarathy avatar image
Parthasarathy asked

sqlserver

i need to pass table variable as parameter to function in sql server 2005.in 2008 we can use table type.but in 2005 how can we pass the table variable(@table) to function from stored procedure. Thanks in Advance
sql-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
Can't be done, at least not simply. Have a read of http://www.sommarskog.se/arrays-in-sql-2005.html - see if it helps.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.