Answer Posted / senthilsjc

This query delete duplicate records(but not delete both
duplicate)
set rowcount 1
delete yourtable
from yourtable a
where (select count(*) from yourtable b where b.name=a.name
and b.age=a.age)>1
while @@rowcount >0
delete yourtable
from yourtable a
where(select count(*) from yourtable b b.name=a.name and
b.age=a.age)>1
set rowcount 0

How to defragment table indexes?

976

---

What are the differences between left join and inner join in sql server?

1094

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1897

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

975

---

What is the index requirement in SQL Azure?

98

---

What program is used to store the data source file?

955

---

What is resource governor in sql server?

985

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1197

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1013

---

Is sql server 2016 free?

928

---

What are various limitations of the views?

1049

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2509

---

What is save transaction and save point?

1194

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

---

How extra digits are handled with numeric data type literals?

956

---