Answer / nageswara rao.g

hi friends this is answer as per me,

when static cursor used the cursor lifespan is within
the program only(pl/sql program).its life end when it comes
outside the program
when dynamic cursor is used the cursor is accessable by
outside other programs with in same connection ,not another
connection.i.e its lifespan is with in connection

Answer / gunjan sapra

hi neeraj,
this is not the answer.
answer about the life span of curser.

Answer / sumit

The Life Span of the Cursor is till the runtime of the
stored procedure/function in which the cursor is being used
in sql server

Answer / neeraj

when curser starts and that is curser life span

Answer / sumit

The Life Span of the Cursor is till the runtime of the
stored procedure/function in sql server 2005

How to implement service broker?

0 Answers  

---

What is isolation levels?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

---

To find second largest salary in Employee table

17 Answers   CSS,

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

how to know Who Is Blocking Your SQL Server?

4 Answers  

---

What are commonly used mssql functions in php?

0 Answers  

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---