Updating joined tables in sql server

Both tables are compared using the condition, defined in the Merge Statement.

This condition determines how Source Table matches with destination table.

Mst Product(ID, Product_ID, Product_Name) VALUES (32, 'MED145', 'Reducurzol') INSERT dbo.

updating joined tables in sql server-46

Here records are considered as matching when data within the joined columns are the same.Mst Product(ID, Product_ID, Product_Name) VALUES (38, 'MED152', 'Ecopurimuc') INSERT dbo.Mst Product(ID, Product_ID, Product_Name) VALUES (39, 'MED153', 'Aerocarpambid') INSERT dbo.Mst Product(ID, Product_ID, Product_Name) VALUES (30, 'MED143', 'Rythmoxabid') INSERT dbo.Mst Product(ID, Product_ID, Product_Name) VALUES (31, 'MED144', 'Omedrozol') INSERT dbo.

Leave a Reply