Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 65261 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / millerdq
The argument that no two nulls are equal does not prove
anything because it's also true that no two nulls are
different.
if null <> null ..... is false
So, one could also claim that a unique key requires that
all values are unique, given that two nulls are not unique,
it is therefore not allowed.
The fact is, ansi standard says multiple nulls are
permitted in a unique key. However, not all dbms's are
compliant. Oracle permits it; SQL Server does not.
So, best answer...it depends on the dbms
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is program debugging?
Is oracle and sql same?
what is the difference between a web-garden and a web-farm? : Sql dba
What does <> sql mean?
What is int identity in sql?
Where the sql database files are stored?
What is not equal in sql?
How to fetch alternate records from a table?
How can we solve sql error: ora-00904: invalid identifier?
What does trigger mean in psychology?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is difference between nchar and nvarchar?
How to call a javascript function from pl sql?
What is difference between joins and union?
what is bcp? When is it used?
