Answer Posted / hiral bhatt

Dear All,

Cursor, its an object in SQL Server and the main advantages
of cursor is that whenevr we need to fetch records in row
by row Manner..

But using cursor, it itself is not a good concept, we have
another alternate for cursor like Temp Table.

Regards
Hiral Bhatt
Sr. Software Engg.

What does COMMIT command do?

1006

---

What is service broker?

955

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1000

---

Call by value and call by reference in procedure and function, with NOCOPY.

1245

---

What is pivot and unpivot?

975

---

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

925

---

What is the difference between functions and scalar functions?

1123

---

Can you explain what is indexed view? How to create it?

850

---

Mention the differences between local and global temporary tables.

951

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1160

---

What does it mean to manipulate data?

942

---

How will you find out if there are expensive SQL statements running or not?

965

---

How you can get a list of all the table constraints in a database? : Sql server administration

948

---

Do you know what is blocking?

899

---

What is the name of reporting services config file and what’s it’s used for?

132

---