Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Table variable as Parameter in a StoredProcedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-10 : 09:04:39
Samred writes "I am wondering if it is possible to have a table variable as parameter to a stored procedure, So I can pass a bunch of rows to the proc."

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-07-10 : 09:24:21
Nope, I don't thinks so.

<O>
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-07-10 : 10:32:21
You can pass multiple rows of data as a CSV though:

http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv

Take a look here as well:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13935
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12538

Go to Top of Page
   

- Advertisement -