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
Can we use ddl statements in stored procedure sql server?
how does a local variable is defined using t-sql? : Transact sql
what are the types of subquery? : Sql dba
Differentiate between % rowtype and type record.
How to display Row Number with Records in Oracle SQL Plus?
What is a field in a database?
What is left join in postgresql?
Can we join 3 tables in sql?
How do I delete a trigger?
what is rdbms? : Sql dba
Can you load data into multiple tables at once? : aql loader
What does partition by mean in sql?
Why trigger is used in sql?
How do you create a unique index?
What is a memo field?
