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 the disadvantages/limitation of the cursor?

566

What command do we use to rename a db, a table and a column?

510

Do I need a report server to run reports in my application?

106

What is the main purpose of having conversation group?

502

What is the minimum recommended amount of ram for sql server 2012 enterprise?

517

What is partition index in sql server?

610

How many full-text indexes can a table have?

559

How to return the top 5 rows from a select query in ms sql server?

598

What is the use of sign function?

565

What is page-level compression?

559

Explain few examples of stored procedure over triggers?

527

Do you know what are different types of replication in sql server?

515

what are candidate key, alternate key and composite key? : Sql server database administration

503

Does partitioning improve performance sql server?

495

What is a view in sql?

584