Yes there can be any number of NULLs. Remember NULL <> NULL. So

Can we have more than one NULL in a column having unique
constraint?

Question Posted / maneesh

Answer Posted / maneesh

Yes there can be any number of NULLs.
Remember NULL <> NULL.

So uniqueness will still be there.

Just try it out.

Maneesh

Is This Answer Correct ?

6 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain what is lock escalation?

1055

What are various ways to enhance the ssrs report?

974

How to change a login name in ms sql server?

1071

What are the steps you can take to avoid “deadlocks”?

970

What is used to replicate sessions between instances in coldfusion clusters?

1066

Detail about query optimizer?

1091

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1938

Why use stored procedures in sql server?

1005

How to set the current database in ms sql server?

1071

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1000

What is use of except clause?

1090

Â Explain what is sql override for a source taLle in a mapping?

1000

What is the query and subquery?

1071

How to get a list of columns using the "sys.columns" view in ms sql server?

954

How to convert a unicode strings to non-unicode strings?

1096