Updating joined tables in sql server Perth chat free no rego no sign up
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.
Using it, we can execute INSERT, UPDATE and DELETE on the target tables within a single query block.
For example, the Source Table is New Product and destination is Productmaster and the primary key is Product ID, then merge condition should be as following: This clause will be used when we want to update or delete the records on the destination table.
Here records are considered as matching when data within the joined columns are the same.
It joins both tables using columns, common in both tables like the primary key.
Based on how column data matches, changes apply to data of target table.