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 is the beast way to write CTE in SQL Server ?
What is the difference between upgrade and migration in sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure?
List out a number of the wants to setup a SQL Server failover cluster?
What is the difference between grant and with grant while giving permissions to the user?
What are the five major components of a dbms?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How do you size a resultset?
What is failover clustering overview?
What is dml command?
what is the difference between Tabular and Matrix report?
How to disable a login name in ms sql server?
What is the difference between implicit and explicit transaction?
What is the concept of optimization?
Explain filtered indexes?