Answer Posted / sivasankar k.c
Primary key: it is clustered index. it not allows null
values. Only one primary in each table.
Unique Key: it is non clustered index. Unique key allows
null values.its allows only one null value. More than one
unique key in table.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What do you mean by 'normalization'?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to locate and take substrings with charindex() and substring() functions?
What is difference between views and stored procedures?
What is a coalesce function?
How many full-text indexes can a table have?
Why we need sql server?
What is the difference between Triggers and Stored Procedure?
What is tablesample?
Define self join in sql server joins?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What does truncate do?
How to connect of datebase with sql express.?
how you can get the list of largest tables in a database? : Sql server administration
