Answer Posted / sharjeel

Hi Friends,

Cursor is more useful programming concept. It is a Data
Type which is used to define multivalue variable. Because
with cursor we fetch more records from tables or rows and
store in a static variable.

After Fetching values in a varible we can use that for
compairing from other values or other cursor.

Regards
Sharjeel Khan
Software Engineer.

What is database architecture? : SQL Server Architecture

541

---

What is the use of commit?

534

---

What is the data tier application?

145

---

Do you know exporting and importing utility?

522

---

What are different replication agents and what's their purpose? : sql server replication

559

---

---

How to round a numeric value to a specific precision?

565

---

Explain time data type in sal server 2008?

542

---

What are the 7 disadvantages to a manual system?

499

---

Are semicolons required at the end of sql statements in sql server 2005?

561

---

What is built-in function?

541

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

492

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

517

---

What are the two authentication modes in sql server?

595

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1504

---

What is the difference between row_number and dense_rank?

436

---