How to use Store Procedure for multiple column database update?
Home > IT Answers > SQL Server > How to use Store Procedure for multiple colum...
KjitSingh
5 pts.
0
Q:
How to use Store Procedure for multiple column database update?
Stored Procedures, INNER JOIN
I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.
ASKED: Mar 24 2009  3:28 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mshen
23535 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Your stored proceedure ran successfully, but it did not find any rows that matched your query. Try rewriting the query or give us more details about what you want to update and how you want to update it so we can help you further.
Last Answered: Mar 24 2009  4:42 AM GMT by Mshen   23535 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29820 pts.  |   Mar 24 2009  3:35PM GMT

Also, don’t forget to mention what database you are using, and post your code if possible.

 
0