Unique Nonclustered Index Creation with - A Transactional Behavior

added by pinaldave
1/11/2010 10:16:53 AM


When we have situation where we are dealing with INSERT and TRANSACTION, we can see this feature in action. Let us consider an example where we have two tables. One table has all the data and the second table has partial data. If you want to insert all the data from the first table to the second table and insert all nonduplicate values, you can use this feature.