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

How you can change a cross join into an inner join?

965

Can multiple columns be used in sql group by clause in ms sql server?

1049

What are indexers?

1084

What stored by the master? : sql server database administration

1106

What is the difference between Triggers and Stored Procedure?

1095

When you should use a low fill factor?

990

What are the difficulties faced in cube development? : sql server analysis services, ssas

1041

Explain what stored procedure sp_replcounters is used for? : sql server replication

1512

How to integrate the ssrs reports in application?

979

Which sql server table is used to hold the stored procedure script?

946

what kind of lan types do you know? : Sql server database administration

978

how many bits ip address consist of? : Sql server database administration

898

Tell me what is difference between clustered and non clustered index?

944

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1010

What are scalar functions?

994