Answer Posted / sandip borkar

There can be 7 types of Cursors in SQL Server
1] Dynamic : Scrollable. Its slowest, and sensitive to all changes in resultset.
2] Keyset : Scrollable. Its slow but faster than Dynamic.Sensitive to Changes like updation and deletion but not insertion
3] Static : Its srollable and faster than both above. We can move forward and backward, but changes are not visible
4] Forward_Only Dynamic : Its not scrollable, but sensitive to changes.
5] Forward_only keyset : Its not scrollable, but sensitive to updation and deletion in resultset but not insertion. We can only move forward and not backward.
6] Forward_only Static : Not sensitive to changes not scrollable.
7] Fast-forward : fastest among all.

Which tcl commands are available on the sql server?

1071

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

914

---

Can multiple columns be used in sql group by clause in ms sql server?

1041

---

What are sub reports?

201

---

How to change a login name in ms sql server?

1068

---

How to use group functions in the select clause in ms sql server?

1046

---

What is function of ROLLUP ?

1078

---

What is the latest version of microsoft sql server?

1037

---

Explain in details security in SQL azure?

121

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1053

---

What is database mirroring?

1105

---

What is the difference between sdf and mdf?

1295

---

Why do you need a sql server?

1097

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2098

---

How you can get a list of all the table constraints in a database?

949

---