Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 64103 Views
- A1 Technology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / hassan khan
A unique key constraint does not imply the NOT NULL
constraint in practice. Because NULL is not an actual value
(it represents the lack of a value), when two rows are
compared, and both rows have NULL in a column, the column
values are not considered to be equal. Thus, in order for a
unique key to uniquely identify each row in a table, NULL
values must not be used. According to the SQL standard and
Relational Model theory, a unique key (unique constraint)
should accept NULL in several rows/tuples — however not all
RDBMS implement this feature correctly.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the differences between binary and varbinary? : Sql dba
What is the use of <> sql?
what is data manipulation language? : Sql dba
How do you write a complex sql query?
Why do we use subquery?
what is the difference between sql and t-sql? : Transact sql
What are inbuilt functions in sql?
Does sql profiler affect performance?
How can you view the errors encountered in a trigger?
What does select count (*) mean in sql?
What are the different types of database management systems?
how can we repair a mysql table? : Sql dba
How to get help at the sql prompt?
how to enter binary numbers in sql statements? : Sql dba
What is dml and ddl?
