Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use more than one null value for unique key?
- 31 Answers
- 66477 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 sql functions? Describe the different types of sql functions?
What trigger means?
What is the difference between the sql*loader and import utilities? : aql loader
Why stored procedure is better than query?
What are sql injection vulnerabilities?
what are all the different normalizations? : Sql dba
What is sql keyword?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Explian rowid, rownum? What are the psoducolumns we have?
how would you get the current date in mysql? : Sql dba
How many functions are there in sql?
What are operators available in sql?
How can I delete duplicate rows?
what is a table in a database ? : Sql dba
How do I copy a table in sql?
