Answer Posted / sunil

CREATE TABLE [dbo].[DupTable](
[Name] [nchar](10) NOT NULL,
[Age] [int] NOT NULL
) ON [PRIMARY]

-- Insert the duplicate data into the table...



Select * from DupTable
go

with Emp AS
(
Select Name,Age, ROW_NUMBER() over (order by Name) as
RowNumber FROM DupTable
)
Delete t1 From Emp as T1, Emp as T2
where T1.Name = T2.Name AND T1.Age= T2.Age and T1.RowNumber
> T2.RowNumber
go

Select * from DupTable
go

How will you monitor replication latency in transactional replication? : sql server replication

1209

---

What is sub-query in sql server?

1258

---

What is replace and stuff function in sql server?

1113

---

Explain the phases a transaction has to undergo?

1111

---

What is role playing dimension with two examples? : sql server analysis services, ssas

1052

---

What are the built in functions in sql server?

1026

---

Difference between group by clause and having clause in SQL?

1026

---

Does group by sort data?

949

---

What is public role in sql server?

1211

---

What is the default value of an integer data type in sql server 2005?

994

---

Please differentiate between a local and a global temporary table?

1059

---

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

1039

---

What guidelines should be followed to help minimize deadlocks?

991

---

Explain about thread and memory management process of SQL?

1016

---

Why use triggers?

1068

---