Answer Posted / kokila

When will be use cursor need to perform following steps:-

1. DECLARE CURSOR

2. OPEN

3. FETCH

4. @@FETCH_STATUS

5. CLOSE

6. DEALLOCATE


1.DECLARE cursor_name CURSOR FOR SELECT_statement;

2.OPEN cursor_name;

3.FETCH cursor_name INTO variable list;

5.CLOSE cursor_name;

6.DEALLOCATE cursor_name;

Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic

what are the different stages of Report Processing?

135

---

What are system databases into sql server (2005/2008) : sql server database administration

1014

---

Tell me what is normalization? Explain different forms of normalization?

1030

---

Suggest a method of joining two tables.

1157

---

Comment,Datatypes are unlimited

2058

---

What does the update command do?

1114

---

What is t-sql script to take database offline – take database online.

1087

---

How use inner join in sql server?

1133

---

What is the difference between cartesian product and cross join?

865

---

Can We Use Data-grids For Our Report In Ssrs?

184

---

Tell me about normalization in DBMS.

995

---

How can I change procedure name in sql server?

1050

---

How to return the top 5 rows from a select query in ms sql server?

1140

---

what are the important architecture components of SSRS?

140

---

How to create indexed view?

1045

---