Answer Posted / santosh kumar sharma

There are 4 types of cursor.
1) Static: Cursor can move to any record but the changes on
the data can't be seen.
2) Dynamic: Most resource extensive. Cursor can move
anywhere and all the changes on the data can be viewed.
3) forward-only: Cursor moves one step forward. Can't move
backwards.
4) Key setdriven: Only Updated data can be viewed. Deleted
and Inserted data cannot be viewed.

What are the differences between user defined functions and stored procedures?

524

---

What is the difference between a view and a stored procedure?

544

---

What is sqlcmd?

547

---

How do I install sql server?

455

---

What is collation sensitivity?

539

---

---

What are the tables in sql?

614

---

Define inner join? Explain with an example?

500

---

How to delete multiple rows with one delete statement in ms sql server?

509

---

How to set database to be read_only in ms sql server?

546

---

What gets stored inside msdb database?

758

---

If no size is defined while creating the database, what size will the database have?

538

---

How can a user-defined datatype be created?

531

---

What is tempdb in sql server?

503

---

What is the difference between for auto and for nested?

498

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

517

---