Answer Posted / senthilsjc

This query delete duplicate records(but not delete both
duplicate)
set rowcount 1
delete yourtable
from yourtable a
where (select count(*) from yourtable b where b.name=a.name
and b.age=a.age)>1
while @@rowcount >0
delete yourtable
from yourtable a
where(select count(*) from yourtable b b.name=a.name and
b.age=a.age)>1
set rowcount 0

What does this statement do @@rowcount?

975

---

How do you Implement SSIS Packages in your Project?

1931

---

What is the importance of a recovery model?

1050

---

Does group by or order by come first?

962

---

What is partition, how will you implement it? : sql server analysis services, ssas

1052

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

971

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1961

---

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1014

---

How can we call UDF(User Define Function) using C# code in ASP.net ?

6890

---

How do I trace a query in sql server?

957

---

What are .mdf files?

943

---

What are the different ways you can create databases in sql server?

1108

---

What are the hotfixes and patches in sql server?

1017

---

Why the trigger fires multiple times in single login?

1213

---

What do you mean by data manipulation language?

1020

---