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
what is schema? : Sql dba
What is cursor and why it is required?
Which certification is best for sql?
what does the t-sql command ident_current does? : Transact sql
What is offset and limit in sql?
What is blind sql injection?
What is number function in sql?
when is the use of update_statistics command? : Sql dba
How do you rename a table in sql?
Explain isolation levels. : Transact sql
how to see the create table statement of an existing table? : Sql dba
What is sql and its types?
What are its different types of dbms?
Can one improve the performance of sql*loader? : aql loader
What is use of term?