What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

Can two tables share a primary key?

0 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

Explain different types of locks in sql server.

0 Answers  

---

---

How can we determine what objects a user-defined function depends upon?

0 Answers  

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

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  

---

Do comments need to go in a special place in sql server 2005?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---