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

Answer Posted / p.prabhu

No we cant have More than One Null in a column which is
having Unique Key Constraint. Because Unique Key Constraint
means having a value only once in the column.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the Prerequisites for Replication?

10740


What is data block and how to define data block size?

692


Explain what are the authentication modes in sql server?

583


How to delete multiple rows with one delete statement in ms sql server?

597


What are the different subsets of sql?

1066






What is dynamic cursor in SQL SERVER?

633


What are database states in ms sql server?

732


Can group by be used without aggregate functions?

568


Do you know how to send email from database?

632


What is difference between rownum and rowid?

590


How do you identify a foreign key?

690


What is difference between order by and group by?

663


Thanks 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?

614


What protocol does sql server use?

602


what is a traditional network library for sql servers? : Sql server database administration

548