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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-27 : 07:58:51
|
| Dev writes "Hi,Is it possible to Pass and/or Return table data types in SQL Server 2000 stored procedures?I know that table data types can be returned in User defined functions, is it possible in stored procedures also?I know that we can pass csv and return csv from stored procedures but i was looking for more advanced way of sending and returning recordsets from stored procedure.ThanksDev" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-27 : 08:07:20
|
| Nope, a table variable is not allowed as a stored proc param.I've used temp tables to allow multiple procs to work with the same rowset.Jay White{0} |
 |
|
|
|
|
|
Passing and Returning table data types in SQL Server 2000 stored procedures