UPDATING DATA IN MULTIPLE TABLES

Question

HI I AM STUCK WITH THE PROBLEM CAN ANYONE HELP ME TO FIGURE OUT THIS CAN WE UPDATE DATA INTO MULTIPLE TABLES AT THE SAME TIME CAN WE DO THIS USING STORED PROCEDURE OR TRANSACTION OR IN ANY OTHER WAYS

Pravin More · Answer

Hi Thiru you cannot update 2 tables in 1 SQL statement. You can write a stored procedure to update both tables. And have the 2 UPDATEs wrapped within a transaction. SQL Server ex.: BEGIN TRANSACTION UPDATE table1 SET col1 = @values1 WHERE... IF @@error 0 BEGIN ROLLBACK TRANSACTION RAISERROR(Unable to update table1 16 1) RETURN END UPDATE table2 SET col2 = @values2 WHERE... IF @@error 0 BEGIN ROLLBACK TRANSACTION RAISERROR(Unable to update table2 16 1) RETURN END COMMIT TRANSACTION Thanx Pravin.

thiru prakash · Answer

hi pravin ThnQ for the reply

Pravin More · Answer

welcome thiru prakash.... if my post help you then please mark it as correct answer. Thanks Pravin.