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 standby server?
Why main is user defined function?
Where are stored procedures in sql server?
Describe how to use linked server?
How do I get to sql server configuration manager?
How to enter comments in transact-sql statements?
What are distributed partitioned views?
What are the advantages of the mirroring?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is master database? : SQL Server Architecture
How to Sync Two SQL Azure Databases?
Can you explain powershell included in sql server 2008?
What do you mean by data manipulation language?
How to create database with physical files specified in ms sql server?
