Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Updating Stored Procedure
March 20, 2013
by using stored procedure ..i am updating my table.
but my requirement is...before updating the table....that data should insert into other table.
Posted Date: March 26, 2013 Points: 20
In the stored procedure you can add an insert statement to insert the values you are going to update.
When you call the stored procedure it would first insert the records into the another table and will update it.
Posted Date: January 07, 2014 Points: 20
In the same stored procedure write procedure to insert the value also. Then it will first insert than will update.
To post reply
Related Questions Related Questions
i got a problem on registration form using stored procedure and classes
How to get output value from stored procedure?
Table name as parameter in SQL Stored Procedure
get value from output parameter from stored procedure
How do I call a Stored Procedure with one associative array as Out put Parameter ?
How to find the Recently accessed stored Procedure?
Where will the text of the stored procedure gets stored?
What is Precompiled in terms of Stored Procedure in Sql Server?
Difference between Stored Procedure and function in Sql Server
Can we have a Stored Procedure and a table with a same name? if not why?
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend