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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and equi join?

486


What are the commands used in DCL?

554


What do you know about system database? : SQL Server Architecture

486


Name some of the open source software that you can use in alternative to SSR?

105


What does REVERT do in SQL Server 2005?

552






Who developed sql server?

524


What is subreport?

96


What are ddl triggers and types of ddl trigger?

602


What are a scheduled jobs?

530


What does truncate do?

531


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

554


What is the difference between clustered index and primary key?

499


What is built-in function?

542


What happens to a trigger with multiple affected rows?

524


What are the instances when triggers are appropriate?

518