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.

write sql program to get the detail of student in a class?

2 Answers  

---

What is a field in a table?

0 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

How do I make a resultset scrollable?

0 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

how to delete duplicate rows from table

9 Answers   CSC,

---

whate is advantages of sql server 2000

0 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

How do I completely remove sql server instance?

0 Answers  

---