Answer Posted / victor

this can help if you want to keep only different records

create table test
(
id int,
name varchar(20)
)

insert into test VALUES(1,'test')
insert into test VALUES(2,'test')
insert into test VALUES(2,'test')
insert into test VALUES(3,'test')
insert into test VALUES(4,'test')
insert into test VALUES(5,'test')
insert into test VALUES(6,'test')
insert into test VALUES(7,'test')
insert into test VALUES(7,'test')
insert into test VALUES(7,'test')



select * from test order by 1

while @@rowcount != 0
begin
delete top (1) test where id in
(
select id
FROM test
GROUP BY id having count(id)>1
)
end

select * from test order by 1


-- At the end you will have only differents IDS

How to create and drop temp table in sql server?

1032

---

How to disable a login name in ms sql server?

1109

---

Mention the differences between local and global temporary tables.

1002

---

How to create an multi-statement table-valued function?

969

---

How to Check if table exists in sql server?

1112

---

List types of tables in SQL Azure?

126

---

Can you explain what are commit and rollback in sql?

917

---

What is 2nf in normalization?

972

---

What are cascading parameters in ssrs reports?

227

---

What methods do you follow to protect from sql injection attack?

998

---

What is difference in performance between insert top (n) into table and using top with insert?

1018

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1103

---

What is blocking?

1038

---

What is the maximum number of index per table?

1050

---

What is snapshot replication?

1035

---