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

How to disable stored procedure sql server?

1596

---

What are the differences between having and where clause.

962

---

What is a cursor, index in sql?

1064

---

How to create a user to access a database in ms sql server using "create user" statements?

943

---

What is the difference between locking and multi-versioning?

981

---

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

1179

---

What is a trigger in sql server?

1159

---

How to create an index on a view?

1060

---

What is a result set object returned by odbc_exec()?

1016

---

What to perform pattern match with the like operator?

874

---

Explain filtered indexes benefits?

995

---

Tell me what are cursors and when they are useful?

944

---

What are transactions and its controls?

1051

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

898

---

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

992

---