Answer Posted / prasant ojha

create a table tbl_info
(
name varchar(250),
age int
)
Enter values

'RAM',25
'SHYAM',34
'RAM',25
'GHANSHYAM',25
'RAM',25

//SQL QUERY TO REMOVE DUPLICATE RECORDS WITHOUR ANY KEY
with info_tbl as(

SELECT *,row_number() over(partition by name order by name)
as record_no from tbl_info
)
delete from info_tbl where record_no>1

What are the components of sql server service broker?

947

---

how can a database be repaired? : Sql server administration

925

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1072

---

How to throw custom exception in Stored Procedure?

994

---

How to make remote connection in database?

956

---

What is the maximum size of sql server database?

946

---

Is there any difference between primary key and unique with the not null condition?

888

---

What does asynchronous call backs means?

1073

---

what is unique and xaml nonclustered index

997

---

What is reference section?

943

---

What is set nocount on?

895

---

Explain hostprotectionattribute in sql server 2005?

961

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1004

---

What is the difference between a stored procedure and a user defined function?

974

---

Define constraints and give an example of their use?

985

---