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’s the distinction between dropping a info and taking a info offline?
What is a trigger in sql server?
Explain what is the difference between a local and a global temporary table?
Explain what are the different index configurations a table can have?
How many types of built in functions are there in sql server 2012?
Explain about thread and memory management process of SQL?
How efficient you are in oracle and SQL server?
What is the difference between executequery () and executeupdate ()?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How to create an inline table-valued function?
How to return the top 5 rows from a select query in ms sql server?
How to delete multiple rows with one delete statement in ms sql server?
How can you list all the columns in a database?
Difference between DELETE and TRUNCATE?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration