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 is the maximum size of sql row in mssql?

1 Answers  

---

Creating Tables Using SELECT

1 Answers  

---

What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  

---

How can we delete Duplicate row in table?

0 Answers   Wipro,

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

what is checksum in sql server.........???

0 Answers   TCS,

---

What is a function? Give some example?

3 Answers  

---

What is a cursor in SQL Server 2000 and their types?

8 Answers  

---

What is the security principal at the database level that represents your session?

0 Answers  

---

How secure is sql server database?

0 Answers  

---