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

if no size is defined while creating the database, what size will the database have? : Sql server administration

540


What is user-defined inline table-valued function?

512


Can an entity have two primary keys?

521


what are the important architecture components of SSRS?

92


What are the two modes of authentication in sql server?

518






How check triggers in sql server?

517


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

578


How to get all stored procedures in sql server?

504


What are cursors and when they are useful?

574


What is #table in sql server?

530


what is a correlated sub-query? : Sql server database administration

480


How to create a new schema in a database?

549


How to achieve Paging of records in SQL SERVER?

590


what are the different types of replication you can set up in sql server? : Sql server database administration

509


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

571