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

Explain acid?

1059

---

What is difference between aggregate and analytic function?

906

---

Explain the use of containers in ssis and also their types?

953

---

How to convert binary strings into integers in ms sql server?

1006

---

Define magic tables in sql server?

1036

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1071

---

What is TDS(Tabular Data Stream) Gateway?

121

---

Different types of keys in SQL?

1082

---

Can you pass expressions to function parameters?

1085

---

What is truncate table?

923

---

How to insert new line characters into strings?

970

---

Does table partitioning improve performance?

949

---

Difference between connected and disconnected database in .net with sql server?

1077

---

can an automatic recovery be initiated by a user? : Sql server administration

935

---

How to use go command in "sqlcmd"?

1184

---