I have a stored procedure that accepts 5 parameters and returns 5 parameters. How do I send data from a table based on some select to the stored procedure and get back the updated information? it seems simple enough but I have never had to do that before from with SQL.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sending parameters to a stored procedure from a table
- Thread starter junkmail
- Start date
You can do something like this:
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
Code:
DECLARE @var1 VARCHAR(10)
DECLARE @var2 VARCHAR(35)
SELECT @var1 = column1, @var2 = column2
FROM mytable-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Status
Similar threads
