Answer Posted / onlymoid

CREATE TABLE dbo.duplicateTest ------Deleting
Duplicates with same id
(
[ID] [int] ,
[FirstName] [varchar](25),
[LastName] [varchar](25)
) ON [PRIMARY]

INSERT INTO dbo.duplicateTest VALUES(1, 'Bob','Smith')
INSERT INTO dbo.duplicateTest VALUES(2, 'Dave','Jones')
INSERT INTO dbo.duplicateTest VALUES(3, 'Karen','White')
INSERT INTO dbo.duplicateTest VALUES(1, 'Bob','Smith')



SELECT * FROM dbo.duplicateTest

SET ROWCOUNT 1
DELETE FROM dbo.duplicateTest WHERE ID = 1
SET ROWCOUNT 0

SELECT * FROM dbo.duplicateTest

Drop table dbo.duplicatetest

What are the differences between sql server and mysql.

1135

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1032

---

What is the difference between writing data to mirrored drives versus raid5 drives

984

---

How to test a dml trigger in ms sql server?

1104

---

What does REVERT do in SQL Server 2005?

1009

---

How is sql used in sql server?

1054

---

What is store procedure? When do you use?

984

---

What are the advantages of sql azure?

140

---

Explain differentiate between a having clause and a where clause?

949

---

Explain what is it unwise to create wide clustered index keys?

1023

---

How to generate create view script on an existing view?

1035

---

What are sub reports?

208

---

How to skip remaining statements in a loop block using continue statements?

1040

---

Explain following error properties?

1058

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1107

---