Answer / swapna

Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.

Answer / ramneet

There is one more diff b/w primary key and unique key that
there is only one primary key in a table but there are more
then one unique keys in a table.

Answer / gowthami radhakrishnana

1)primary key uses clustered index
unique key uses non-clustered index

2)primary key doesn't allow null values
but unique allows one null value

3)there is only one primary key but more than one unique
keys

Answer / ramneet

Primary can be used in foregin key but unique key does not
used.

What sql server means?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

---

What are different types of collation sensitivity?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

List down some advantages of sql stored procedure?

0 Answers  

---

What is a database in ms sql server?

0 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

How to Insert multiple rows with a single insert statement?

0 Answers  

---