Can we use more than one null value for unique key?

Answer Posted / debdut bhaumik

Yes , More than one field can be NULL in a unique Key
column. Because a Null values is not equal to another null
value. So, no duplicate value is there.

Is This Answer Correct ?    26 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sp_pkeys? : Transact sql

713


what is the difference between inner and outer join? Explain with example. : Sql dba

555


what is a stored procedure? : Sql dba

569


how can I make a script that can be bi-language (supports english, german)? : Sql dba

544


How many types of cursors are available in pl/sql?

594






Can we create index on primary key?

537


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

533


Can triggers stop a dml statement from executing on a table?

630


where are cookies actually stored on the hard disk? : Sql dba

592


How many clustered indexes can be created on a table?

601


What are the most important characteristics of pl/sql?

592


Can %notfound return null after a fetch?

604


What is sql rowcount?

568


Can a foreign key be a duplicate?

516


what is the use of set statement in tsql? : Transact sql

546