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 are scheduled tasks in sql server?

1009

---

How to count rows with the count(*) function in ms sql server?

951

---

What is a transact-sql statement batch in ms sql server?

946

---

What is difference statement and preparedstatement?

934

---

Define a cross join?

953

---

Which is the latest version of sql server and when it is released?

1028

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

990

---

How to test a dml trigger in ms sql server?

986

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1023

---

Why people hate cursor?

1096

---

Explain sub-query?

899

---

What is log cache in sql server?

982

---

What are three major types of constraints?

1046

---

List the different types of collation sensitivities in sql server?

973

---

Is INSTEAD OF trigger directly applicable to Table ?

958

---