How to ignore duplicate value Error while inserting the record in unique index?

When unique index is created without any option the default option is IGNORE_DUP_KEY = OFF, which means when duplicate values are inserted it throws an error regarding duplicate value.

such as
 
Msg 2601, Level 14, State 1, Line 9
Cannot insert duplicate key row in object 'dbo.QODT4' with unique index 'Q4_INDEX'.

If option is set with IGNORE_DUP_KEY = ON then the duplicate values are inserted it does not thrown an error but just displays warning.
 
such as
(1 row(s) affected)
Duplicate key was ignored.

Comments

Post a Comment

Popular posts from this blog

Display multiple marker point on Google Map with same location or same Longitude,Latitude

 Display multiple marker point on Google Map with same location or same Longitude, Latitude <!DOCTYPE html> <html> <head>     <title>Google Map</title> <!-- For Google Map Style Sheet--> <style type="text/css">     #map_canvas     {         height: 450px;         width: 980px;     }     .infowindow     {         font-size: 12px;         width: 200px !important;         font-family: verdana;     }     @media print     {         #map_canvas         {             height: 950px;   ...
Read more

Comparing cursor vs. WHILE loop performance

Cursors Cursors are a looping construct built inside the database engine and come with a wide variety of features. Cursors allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values. Depending on the type of cursor you request, you can even fetch records that you’ve previously fetched. Because a cursor is an actual object inside the database engine, there is a little overhead involved in creating the cursor and destroying it. Also, a majority of cursor operations occur in tempdb, so a heavily used tempdb will be even more overloaded with the use of cursors. The types of cursors used are very important in terms of performance. Below is a list of the available cursor types as listed on     FORWARD_ONLY Specifies that the cursor can only be scrolled from the first to the last row. FETCH NEXT is the only supported fetch option...
Read more

Implementing Zoom functionality in asp.net

Zoom functionality in asp.net 1. Write the Below code in the  <head> Tag  <script type="text/javascript">         function BrowserZoomPluse() {            nzoom = parseInt(divTest.style.zoom) + 30 + '%';             divTest.style.zoom = nzoom ;         }         function BrowserZoomMinuse() {             nzoom = parseInt(divTest.style.zoom) - 10 + '%';             divTest.style.zoom = nzoom ;         }         function ResetZoom() {             nzoom = parseInt(divTest.value);       ...
Read more