Answer Posted / rama krishna

This will help u a lot bcz dynamically it will delete
duplicates



create table tbl1 (col1 int)





insert into tbl1 values(1)
insert into tbl1 values(1)
insert into tbl1 values(1)
insert into tbl1 values(2)
insert into tbl1 values(2)
insert into tbl1 values(2)
insert into tbl1 values(2)
insert into tbl1 values(3)
insert into tbl1 values(3)


select * from tb1


set rowcount 1
select 'start'

while @@rowcount > 0
delete a from tbl1 a where (select count(*) from tbl1 b
where a.col1 = b.col1)>1
set rowcount 0
select * from tbl1
set nocount off

What is the use of partition by in sql server?

968

---

Are connections to sql server encrypted?

1053

---

How check triggers in sql server?

1047

---

What is difference between delete & truncate commands?

1140

---

what's sql server? : Sql server database administration

1051

---

What is an indexed view?

1007

---

Does partitioning help performance?

994

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1014

---

Write the syntax for stuff function in an sql server?

1072

---

Explain the difference between functions and stored procedures in sql server?

1018

---

Describe the functionalities that views support.

1146

---

What are the underflow and overflow behaviors on float literals?

1165

---

What do you mean by sql server 2005 express management tools?

1353

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

1004

---

What are the basic features of a trigger in ms sql server?

1264

---