Home Forums Article Discussions Article Discussions by Author Discuss content posted by Marianna Petrovich Unique constraint on a nullable column RE: Unique constraint on a nullable column
Carlo Romagnano
SSC-Insane
Points: 22599
More actions
December 2, 2010 at 2:40 am
#1257764
INSERT ... WHERE ...
... and UPDATE ????
I could insert NULL and then change (UPDATE) it to an existing value!
The solution is insert/update by stored proc, but the risk to miss the right value is high.