Answer / Vipul Agrawal

In SQL Server, a table can have only one clustered index because a clustered index determines the physical order of data in the table. When multiple clustered indexes are created on a table, it leads to fragmentation and impacts performance. By allowing only one clustered index per table, SQL Server ensures that data is organized efficiently.n

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,

---

Explain system views?

1 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

How to create and drop temp table in sql server?

1 Answers  

---

What is similarity and difference between truncate and delete in sql?

1 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

1 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

Can you type more than one query in the query editor screen at the same time?

1 Answers  

---

What is the difference between functions and stored procedures?

1 Answers   Accenture,

---

what is node in sql server?

2 Answers   CarrizalSoft Technologies, Google, NIIT, Nittany, TATA,

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---