| Author: vipul 04 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
Hi,
if you define any column as "UNIQUE KEY" you can store null value in that by default.
Please Rate This Answer If They Helpful
Thanks & Regards
Patel Vipul
|
| Author: Anil Kumar Pandey 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
if there is only a single record having NULL values.. if multiple records are having NULL value UNIQUE constraint will be violated as there are multiple common values..
Thanks & Regards
Anil Kumar Pandey
|
| Author: Melchior 04 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
UNIQUE Key will allow any data (whether it is NULL or Not) only once.
|
| Author: Manick 04 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
If u defined a Column as Unique, it will allow only one 'NULL' value.
Also it will not allow duplicate values.
Regards,
Manick
|
| Author: sriram 23 Nov 2009 | Member Level: Bronze | Rating: Points: 2 |
In Unique Key u can able to store only one Null values ..
u cant to store more null values..
Sriramramaswamy
|