Answer / sakthi

Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.

Composite key:

It same as Primary key but combination of more that one
column.

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

What is partition index in sql server?

0 Answers  

---

Why use update_statistics command in sql server?

0 Answers  

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

What is efficiency data?

0 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---

What happens if null values are involved in datetime operations?

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

What is the difference between drop table and truncate table?

0 Answers  

---

What are subqueries in sql server? Explain its properties.

0 Answers  

---