I have a table in which a non-primary key column has a unique index on it.
If I am inserting a record into this table with a duplicate column value for the indexed column, then what will be the error number of the error in above scenario? OR How could I find this out?
Open a query analyzer and try to manually insert a value into the table and see what SQL complains..
|||The error number for inserting duplicate value in a column of unique index is : 2601.
No comments:
Post a Comment