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 get max 100 values from sql server

7 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

What is an active database?

0 Answers   HCL,

---

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

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

0 Answers  

---

what are the types of indexes? : Sql server database administration

0 Answers  

---

Explain features of analysis services?

0 Answers  

---

What xml support does the sql server extend?

0 Answers  

---

Can foreign key be deleted?

0 Answers  

---