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 are views in ms sql server?

1025

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1000

---

Explain what is scheduled job and how to create it?

904

---

Can we write trigger for view?

954

---

Why should one not prefix user stored procedures with ‘sp_’?

987

---

How to create a simple stored procedure in ms sql server?

979

---

What are functions in the sql server?

1128

---

What are the 2 types of classifications of constraints in the sql server?

1048

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

895

---

Can you create a logon trigger in sql server 2005 express edition?

1032

---

What is the difference between implicit and explicit transaction?

964

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1079

---

What are scheduled tasks in sql server?

1011

---

What are the new features in sql server 2016?

930

---

What is user-defined functions? What are the types of user-defined functions that can be created?

981

---