Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
table variable as an input or output param to stored proc
- Thread starter vadimg
- Start date
No, but you can do a final select which returns a recordset. It just doesn't use the actual Return function.
To get table information into an sp is harder. You need to concatenate the information from a field into one long string variable and then break it down to a table within the stored procedure.
or of course you can simply join to the table information you want (if it is already stored) to perform the action you want to perform.
Questions about posting. See faq183-874
To get table information into an sp is harder. You need to concatenate the information from a field into one long string variable and then break it down to a table within the stored procedure.
or of course you can simply join to the table information you want (if it is already stored) to perform the action you want to perform.
Questions about posting. See faq183-874
- Status
Similar threads
- Locked
- Question
- Locked
- Question