Answer Posted / krishna sandeep

Advantage:

you can do row vise validation from a table

Disadvantage:

of example you are retrieving 100 row...
every single row you retrieve will hit the server as a
single select query so performance will be low.

What is a result set object returned by mssql_query()?

1158

---

What is 'write-ahead log' in sql server 2000 ?

1057

---

How you can change a cross join into an inner join?

973

---

What is postgresql server?

1006

---

Can a unique index be created on a column, which contains null?

919

---

What does this statement do @@rowcount?

972

---

What is a raid and what are different types of raid configurations?

1267

---

What is difference between group by and having?

943

---

What are views used for?

1015

---

How to drop an existing table?

1008

---

How to move database physical files in ms sql server?

1034

---

How does Report Builder support Analysis Services cubes?

154

---

How to change the ownership of a schema in ms sql server?

1194

---

List out some of the requirements to set up a sql server failover cluster?

1034

---

When should you use an instead of trigger?

956

---