SQL can I have a “conditionally unique” constraint on a table?

by

If you are using SQL Server 2008 a Index filter would maybe your solution:

http://msdn.microsoft.com/en-us/library/ms188783.aspx

This is how I enforce a Unique Index with multiple NULL values

CREATE UNIQUE INDEX [IDX_Blah] ON [tblBlah] ([MyCol]) WHERE [MyCol] IS NOT NULL

More Related Contents:

  1. Insert an image in a column of a table that already has 5 columns
  2. Insert results of a stored procedure into a temporary table
  3. How to SELECT FROM stored procedure
  4. SET versus SELECT when assigning variables?
  5. Is there any difference between IS NULL and =NULL
  6. sql query to return differences between two tables
  7. SQL Server – transactions roll back on error?
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Difference between a User and a Login in SQL Server
  10. SQL statement to select all rows from previous day
  11. Concatenate values based on ID
  12. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  13. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  14. Splitting delimited values in a SQL column into multiple rows
  15. Insert Picture into SQL Server 2005 Image Field using only SQL
  16. Execute Stored Procedure from a Function
  17. varbinary to string on SQL Server
  18. SQL : in clause in stored procedure:how to pass values
  19. SQL GROUP BY CASE statement with aggregate function
  20. separate comma separated values and store in table in sql server
  21. Best way to do nested case statement logic in SQL Server
  22. Restrict an SQL Server connection to a specific IP address
  23. SQL Server 2005 ROW_NUMBER() without ORDER BY
  24. Can an INNER JOIN offer better performance than EXISTS
  25. SQL server identity column values start at 0 instead of 1
  26. How do you copy a record in a SQL table but swap out the unique id of the new row?
  27. How to compare dates in SQL Server
  28. How do I expand comma separated values into separate rows using SQL Server 2005?
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL query for parent-child chain

Leave a Comment