Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PAD_INDEX = OFF,
- STATISTICS_NORECOMPUTE = OFF,
- IGNORE_DUP_KEY = OFF,
- ALLOW_ROW_LOCKS = ON,
- ALLOW_PAGE_LOCKS = ON
- ON
- A warning message will occur when duplicate key values are inserted into a unique index. Only the rows violating the uniqueness constraint will fail.
- OFF
- An error message will occur when duplicate key values are inserted into a unique index. The entire INSERT operation will be rolled back.
- IGNORE_DUP_KEY cannot be set to ON for indexes created on a view, non-unique indexes, XML indexes, spatial indexes, and filtered indexes.
- To view IGNORE_DUP_KEY, use sys.indexes.
- In backward compatible syntax, WITH IGNORE_DUP_KEY is equivalent to WITH IGNORE_DUP_KEY = ON.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement