Answer Posted / nageswara rao
cursor acts as datatype for holding composite
variable.composite variable hold more than one value at a
time.
when ever u declare a cursor it tells to sqlserver that
memory is create for that cursor
whenever u open the cursor it executes select statement in
declare section and reserves memory stored the result of
execution in this memory.and reserves pointer to the before
first
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can you know that statistics should be updated?
What is use of term?
What are different functions in sql?
how would concatenate strings in mysql? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
Is sql microsoft?
What are pl sql data types?
What is the difference between sql and isql*plus?
What is sql server and ase?
Can we write dml inside a function in sql server?
how can we know the number of days between two given dates using mysql? : Sql dba
How do I run a pl sql program?
What is the difference between a procedure and a function?
What does varchar include?
What are primary key and foreign key and how they work?