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

What is the difference between indexing and hashing?

1152

---

What is single-user mode?

921

---

What is table-valued sub query?

955

---

Explain the different index configurations a table can have?

930

---

What is key set driven?

942

---

How do database indexes work?

1002

---

Please illustrate physical database architecture? : SQL Server Architecture

973

---

Explain time data type in sal server 2008?

915

---

What is bit data type? What's the information that can be stored inside a bit column?

909

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1070

---

List out the differences between global and local temp tables in sql server?

1047

---

Do you know nested transaction?

952

---

What do you mean by a Composite primary key?

1091

---

Explain the collation?

1097

---

Explain identity in sql server?

995

---