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 are analytic functions in sql?
What are the types of operators available in sql?
Enlist some predefined exceptions?
what is a trigger? : Sql dba
What is the maximum number of columns in sql table?
what are date and time functions in mysql? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
Do foreign keys improve performance?
Is left join inner or outer by default?
Is sql better than excel?
Can we use join in subquery?
Which is better join or subquery?
What is recursive stored procedure?
What are all ddl commands?
What does the base_object_type column shows in the user.triggers data dictionary view?