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)
 Stored Procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-11-15 : 07:36:20
Pankaj writes "Can we pass a table data type parameter in a stored procedure ? If yes the how? If no then why ? B'coze we can return the tble data type from a stored procedure."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-11-15 : 07:37:45
quote:
Can we pass a table data type parameter in a stored procedure?
No.
quote:
If no then why
Don't know. You can always create and populate a temp table with the data you need to process, write your procedure to use that temp table, then call the procedure.
Go to Top of Page
   

- Advertisement -