Unique Nonclustered Index Creation with - A Transactional Behavior(blog.sqlauthority.com)
submitted by
pinaldave(9662) 2 years, 1 month ago
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.
|category: Database
|Views: 62
tags:
SQLAuthority pinaldave SQLServer Database SQL another
Everyones tags:
Your Tags: