Hi friends.
Is Unique key accept null value. In my application it does not accept multiple null value.but from i studied it accept null for unique column.suppose it accept, how can i modify my unique column table for accepting null value
Advance Thanks
Loading
Riddhi ValechaPosted Nov 6, 2012, 4:10 AM
Incase you want that the table column should accept multiple null values, then tick the column - Allow Null, and also do not assign any key(primary or unique key) to that column in design time.
Sandeep Singh ShekhawatPosted Nov 4, 2012, 4:29 AM
Primary key column does not accept null values But Unique key column can take only one single NULL value not multiple null values in column of sql server database.
So please check how can two row will be unique if both have same Null value for a unique column? So we can only have only one null value in unique filed/column.