SQL Server UNIQUE constraint
I want to create a constraint on a field.
I need uniqueness as long as the field is not null (allow multiple nulls).
How am I going to do this?
[161 byte] By [panayotisk] at [2007-11-18 17:23:21] 
Hi,
I want to create a constraint on a field.
I need uniqueness as long as the field is not null (allow multiple nulls).
How am I going to do this?
# 1 Re: SQL Server UNIQUE constraint
I believe you can't..you can create a triggers to handle this setuation..
one trigger for insert and the other for update.And check if the data violates your rules.
hspc at 2007-11-9 13:37:15 >
# 2 Re: SQL Server UNIQUE constraint
Yes, it is true. The problem I'm having now is actually make this trigger work since I need to use dynamic SQL. I posted this in another thread.Thanx a lot
Panayotis
panayotisk at 2007-11-9 13:38:15 >
