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.

How do you start single user mode in clustered installations?

989

---

What are the types of resultset?

1015

---

How is foreign key related to primary key?

1014

---

How will you make an attribute not process? : sql server analysis services, ssas

1160

---

What does indexation mean?

1033

---

What is the difference between for trigger and after trigger?

1163

---

What is the synonym of join?

1018

---

Explain magic tables in sql server?

1106

---

Why use identity in sql server?

1173

---

When we should use and scope of @@identity?

1047

---

You want to use a perspective in an mdx query. How do you select the perspective?

246

---

What language is sql server written in?

1081

---

Define self join in sql server joins?

997

---

What is transaction server auto commit?

1117

---

What are the limitations/drawbacks or ssrs 2008 r2?

152

---