Answer Posted / basha

Following are different types of cursors available in SQL Server 2005 :

Base table
Static
Dynamic
Forward-only/Read-only
Keyset-driven

Base table: Base table cursors are the lowest level of cursor available. Base table cursors can scroll forward or backward with minimal cost, and can be updated

Static: Cursor can move to any record but the changes on the data can’t be seen.

Dynamic: Most resource extensive. Cursor can move anywhere and all the changes on the data can be viewed.

Forward-only: Cursor moves one step forward, can’t move backwards.

Keyset-driven: Only updated data can be viewed, deleted and inserted data cannot be viewed.

Define union, union all, minus, intersect?

985

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1142

---

Why main is user defined function?

1017

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1035

---

What is use of except clause?

1093

---

How do I make a resultset scrollable?

966

---

How to round a numeric value to a specific precision?

1076

---

How to verify a user name with sqlcmd tool?

1087

---

Can a table have 2 foreign keys?

911

---

How can you ensure that the database and sql server based application perform well?

1085

---

Do you know what is replace and stuff function in sql server?

1023

---

What is the difference between DataRow.Delete() and DataRow.Remove()?

1231

---

Tell me what is normalization? Explain different forms of normalization?

1033

---

explain different types of cursors? : Sql server database administration

1095

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

924

---