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

Explain about unique identifier data type in sql server?

0 Answers  

---

Does a sql server 2005 select statement require a from?

0 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---

---

How to set a database state to offline in ms sql server?

0 Answers  

---

Does the order of columns in update statements matter?

0 Answers  

---

How to implement service broker?

0 Answers  

---

Explain the different types of joins?

0 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

What is the difference between grant and with grant while giving permissions to the user?

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---