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
What is the difference between inner join and equi join?
What are the commands used in DCL?
What do you know about system database? : SQL Server Architecture
Name some of the open source software that you can use in alternative to SSR?
What does REVERT do in SQL Server 2005?
Who developed sql server?
What is subreport?
What are ddl triggers and types of ddl trigger?
What are a scheduled jobs?
What does truncate do?
How to convert a unicode strings to non-unicode strings?
What is the difference between clustered index and primary key?
What is built-in function?
What happens to a trigger with multiple affected rows?
What are the instances when triggers are appropriate?