Answer / Shreyansh Nath

A forward-only or read-only cursor in SQL Server allows you to read data sequentially from a result set in one direction, typically forward, and it does not support scrolling to previous rows. It is optimized for speed since it skips the overhead associated with updating, deleting, or inserting data. This type of cursor is commonly used when you simply want to loop through data without making changes.

What are approximate numeric data types in ms sql server?

1 Answers  

---

Different types of keys in SQL?

1 Answers   Infosys,

---

What is ems sql management studio? : sql server management studio

1 Answers  

---

How to create a dml trigger using create trigger statements?

1 Answers  

---

What are the difference between “where” and “having” clause in sql server?

1 Answers  

---

How sql server enhances scalability of the database system?

1 Answers  

---

How to loop through returning rows?

1 Answers  

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---

What is a trace frag?

1 Answers  

---

How can we delete Duplicate row in table?

1 Answers   Wipro,

---

Explain database normalization?

1 Answers  

---