Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Unique or empty string constraint?

Author  Topic 

m6rk
Starting Member

1 Post

Posted - 2009-04-14 : 09:45:50
re: SQL 2005 (running in SQL 2000 compatability mode) -

Is there a way to define a column constraint that will allow for multiple empty string, multiple null, and only unique non-empty string values?

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-04-15 : 00:54:55
for multiple null values as nullable column
for unique values use unique constriant
Go to Top of Page

mithun.gite
Starting Member

3 Posts

Posted - 2009-04-15 : 02:03:07
IF U LOOKING FOR A COLUMN HAVING UNIQUE CONSTRAINT WITH MULTIPLE NULLS , THEN IT IS POSSIBLE,, IF U LOOKING FOR SAME THEN REPLY SO I CAN GUIDE U HOW TO ACHIVE IT.....

Thanks & Regards,
Mithun Gite
Go to Top of Page
   

- Advertisement -