What is the purpose of IGNORE_DUP_KEY?

 Posted by Niladri.Biswas on 4/26/2013 | Category: Sql Server Interview questions | Views: 2316 | Points: 40
Answer:

Changes the behavior when duplicate keys are encountered when performing
inserts into a table. When enabled, rows violating the key constraint will fail. When
the default behavior is disabled, the entire insert will fail.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response