Sql updating multiple tables simultaneously dna dating app

sql updating multiple tables simultaneously-3sql updating multiple tables simultaneously-21sql updating multiple tables simultaneously-66

Hopefully, someone with a lot more experience will be able to point out how I can do it in reality. In SQL Server you can chain stored procedures using EXEC[UTE].

Very similar to your pseudo, except: ALTER PROCEDURE dbo.

database and specify which tables should be compared.

You can review the data and decide which changes to synchronize.

Master Stored Proc ( @Parameter1 tinyint, @Parameter2 varchar(50), @ID int, @Parameter A int, @Parameter B int, @Parameter N1 int, @Parameter N2 int ) AS BEGIN TRANSACTION EXECUTE Stored Proc1 Parameter1, Parameter2 EXECUTE Stored Proc2 Parameter A, Parameter B ....