What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

What is global temp table?

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 scrollable cursor?

0 Answers  

---

Will the writetext statement activate a trigger?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

How can I change procedure name in sql server?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---