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

why would you use sql agent? : Sql server database administration

1221

How to use go command in "sqlcmd"?

1213

How to defragment indexes with alter index ... Reorganize?

1088

Is mysql better than sql server?

1067

How to remove duplicate rows from table?

1253

What is trigger in salesforce?

987

When does a workload on SQL Azure get throttled?

131

What do you mean by the term 'normalization'?

1217

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2015

What is sql server profiler trace data file?

1114

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1335

How to get a list all databases on the sql server?

1108

How to use subqueries in the from clause in ms sql server?

1166

Explain iaas, paas and saas?

Are null values the same as that of zero or a blank space?

1042