| Author: Narayanan Sukumaran 29 Sep 2008 | Member Level: Gold Points : 1 |
Hi Athira Appukuttan ,
Do you have any INDEX related articles?
What is clustered index and Non-clustered index? Difference?
How to crete clustered index and Non-clustered index?
|
| Author: Bunty 02 Oct 2008 | Member Level: Diamond Points : 1 |
Hi,
Athira,
We can have at the max one null value in unique constraint not many.
so just check that.
Regards
S.S.Bajoria
|
| Author: anil 03 Oct 2008 | Member Level: Silver Points : 1 |
Hi
Aathira,
What is de diff b/w clustered index and Non-clustered index?
thanks,
Anil...
|
| Author: Sriram 05 Oct 2008 | Member Level: Gold Points : 2 |
Hi,
Primary Key : Primary Key Restrict Duplicate Values and null Values .Each Table Can have only one primary Key.
Unique Key: Unique Key Restrict Duplicate Values and allow only one Null Values.
Primary Key Default is Clustered Index its Sequential Order.
Unique Key Default is Non Clustered Index
Thanks and Regards
SriramRamaswamy
|
| Author: Roopesh Babu Valluru 14 Oct 2008 | Member Level: Gold Points : 1 |
yes man...only one null is allowed for unique key column...pls try to correct it...
|