Answer Posted / vaishali

set rowcount 1
delete from stud
where (select count(*) from stud a where stud.roll_no =
a.roll_no) > 1
while @@rowcount<>0
delete from stud
where (select count(*) from stud a where stud.roll_no =
a.roll_no) > 1
set rowcount 0

How fixed length strings are truncated and padded?

1022

---

What is the chart in report?

165

---

What are the character string functions supported by sql server 2005?

1074

---

What is a system database and what is a user database?

1138

---

What functions can a view be used to performed?

1115

---

What is a database table?

1021

---

What are the different types of sql server replication? : sql server replication

1367

---

How to define and use table alias names in ms sql server?

1208

---

What action plan is preferred if sql server is not responding?

1157

---

How to resolve the orphan use problem? : sql server security

1072

---

Would you store your query in a ssrs report or a database server? State the reason why?

157

---

What is the user of Primary key?

1029

---

How to write character string constants or literals in ms sql server?

1066

---

How do I install only the client tools of sql server 2000?

1125

---

Give the query of getting last two records from the table in SQL SERVER?

1008

---