Answer / ramya gurrala

Cursor is a pointer(in c/java).Cursor work with DML and information can be accessed.

Cursor is required to process each row individually for queries which return multiple rows.

Advantages:1)We can do operations on each row.
2)Response time is good.
3)Cursors are faster than the while loop.

Disadvantages:1)Repeated network round trips.
2)Occupies more resources and temporary storage.

Mention the differences between local and global temporary tables.

0 Answers  

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

Write an sql query for deleting duplicate rows?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

How to create an identity column?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

Explain about system database?

0 Answers  

---

what is a transaction? : Sql server database administration

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

What command do we use to rename a db?

5 Answers   IBM,

---