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

Can group by and orderby be used together?

995

---

What objects does the fn_my_permissions function reports on? : sql server security

1019

---

What is sql server used for?

1023

---

How to retrieve error messages using odbc_errormsg()?

1033

---

Why are sql functions used?

1099

---

what are the reporting service components in SSRS?

163

---

How do I schedule a sql server profiler trace?

967

---

What is “asynchronous” communication in sql server service broker?

1015

---

What are distributed partitioned views?

1050

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1001

---

What are number line correlation administrators will use while working with a subquery?

1152

---

What is the concept of optimization?

1024

---

Write SQL queries on Self Join and Inner Join.

1128

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1837

---

Explain the disadvantages of cursors?

1119

---