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 do I find the port number for sql server?

971

---

What are four major operators that can be used to combine conditions on a where clause?

1054

---

Which sql server table is used to hold the stored procedure script?

948

---

Explain what is row_number function?

1039

---

What is sql language?

1146

---

What is Dependency Injection and provide example?

1118

---

How to insert data with null values?

1034

---

Mention what are the different types of ssrs reports?

152

---

How to get the definition of a user defined function back?

1044

---

How to delete duplicate rows from table except one?

990

---

How do you handle datasets larger than 50 gb?

162

---

How to receive returning result from a query?

1126

---

What is ms sql server triggers?

1013

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

---

What are the steps to follow to configure SQL*Net?

1044

---