MS Sql Server Notes

Sunday, 8 February 2015

How to accept multiple nulls for unique key column in sql server

CREATE UNIQUE NONCLUSTERED INDEX idx_yourcolumn_notnull
ON YourTable(yourcolumn)
WHERE yourcolumn IS NOT NULL;
Posted by Dhanunjay at 23:59 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

About Me

Dhanunjay
View my complete profile

Blog Archive

  • ▼  2015 (1)
    • ▼  February (1)
      • How to accept multiple nulls for unique key column...
  • ►  2014 (10)
    • ►  December (1)
    • ►  November (3)
    • ►  October (2)
    • ►  September (1)
    • ►  August (3)
Simple theme. Powered by Blogger.