For example: If we have a table CUSTOMER, and we need to update address. But when we have a requirement of updating more than one column in a table, then what is the best process to implement? Well, irrespective of how many columns you need to update, you can always go with SCD logic as long as you need to update for the same primary key in target and all the updates are of same SCD type.
The condition where you will be comparing the source rows against the target will have a comparison of the one or more columns against which you are maintaining the history. Will get back to you in case i have any query further.
So, SCD goes fine in the scenario where we need to update many columns in the same table against the same primary key in the target.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
In this article I will show you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
The column values returned by the subquery are assigned to the columns in the column list in order. WHERE search_condition Chooses which rows to update in the database table.The old column values are used on the right side of the equal sign.SET column_name = (subquery3) Assigns the value retrieved from the database by list.The first value is assigned to the first column in the list, the second value is assigned to the second column in the list, and so on. Only rows that meet the search condition are updated.If you omit this clause, all rows in the table are updated.