Primary key:it can not be null Unique:it can have only one null value in

what is difference between primary key and Unique

Question Posted / naresh

Answer Posted / naresh

Primary key:it can not be null

Unique:it can have only one null value in a table.

Is This Answer Correct ?

13 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is difference between delete and truncate commands?

1172

What is the most common trace flags used with sql server?

1119

What is triggers and its types?

1067

What is inner join in sql server joins?

1096

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1960

What is a raid and what are different types of raid configurations?

1323

Explain the properties of subqueries in sql server?

1141

What is the use of group by clause?

992

How to create indexed view?

1106

What does Master database contains?

1182

What do you understand by intent locks?

1061

How many null values we can have in a unique key field in sql server?

1011

What are cursors in ms sql server?

1241

What is lock escalation? : sql server database administration

1198

Define tool Manage Statistics in SQL Server 2000 query ?

1167