What are the capabilities of Cursors?
What are the capabilities of Cursors?
Answer
Cursors can support various functionalities that are listed here.
Cursor allow to position at specific rows of the result set.
Cursor can retrieve one or more rows in the result set.
Cursor allows modification to the rows in the result set.
Sql server - What are the capabilities of
Cursors? - Feb 11, 2010 at 11:55 AM by Shuchi Gauri
What are the capabilities of Cursors?
Capabilities of cursors:
-
Cursor reads every row one by
one.
-
Cursors can be used to update a set of
rows or a single specific row in a resultset
-
Cursors can be positioned to specific
rows.
-
Cursors can be parameterized and hence are
flexible.
-
Cursors lock row(s) while updating
them.
Also read
Cursors behavior can be controlled by dividing them into cursor
types: forward-only...............
Define Data definition language, What are the capabilities of
Cursors?..........
Restrict Query Result for performance optimization, Restrict
columns in the SQL query, Use stored procedure instead of heavy duty
queries, Avoid SQL cursor for optimal performance,
Use constraints instead of trigger, Use table variable instead of
temporary tables............
Answer - Temporary Stored Procedure is stored in TempDB database. It
is volatile and is deleted once connection gets terminated or server
is restarted......
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....
|
