0
The purpose of a cursor in a database is to provide an option to the programmer using which he/she can iterate through the contents of a table one record at a time and use it for processing. A sample cursor can be created using the below statement
DECLARE cursor_employee CURSOR FOR SELECT * FROM tbl_employee_info
The above cursor cursor_employee will contain the contents of the table tbl_employee_info and can be used by the programmer for manipulation one record at a time.
A Cursor may act like a DataStructure . it stores the record coming from the base table . in if we want ot retrive the date very fastly we will user cursors.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
Difference between the delete key an the back space?
The backspace key deletes to the left of the cursor, and the delete key deletes to the right of the cursor.
Which cursor attribute do you reference to determine the number of records that were deleted by a DELETE statement?
Sql%rowcount
What is the basic terminology of dbms?
Acid cursor data database field primary & foreign keys procedure & function odbc & oledb normalization trigger
What is the purpose of a number line?
the purpose of a number line is to help math.
Does function and purpose mean the same thing?
No, for function is it's actual ability of doing something while it's purpose it what it is intended to do.
What is the purpose of the cell cursor in an excel sheet?
to select cells
Where are some of the places that one could find tutorials for TSQL?
There are many places one might go to find a tutorial for 'TSQL.' In addition the W3School website, which provides website information, one might also check the local library.
What is the name of the SQL language used in SQL Server stored procedures?
Transact SQL (TSQL)
How do you put SQL Server in hot backup mode?
Use the TSQL backup command to backup an active database.
What is the purpose of a serial mouse?
Like all other mice, the purpose of a serial mouse is to move a cursor or pointer across a computer display.
What is the function of the cursor?
the function of cursor control keys it helps to move the cursor.
What is the cursor on ms Excel is called the?
The cursor is called a cursor in MS Excel.
What is the function of the cursor key?
the function of cursor control keys it helps to move the cursor.
When you type in your password you see a blinking vertical bar What is this called and what is its purpose?
It is called a cursor and tells you that the keyboard entry will start at this point on the screen.
What part of speech is cursor?
"Cursor" is a noun.
Why is the computer cursor called the cursor?
Its ugly
How do you change a mouse cursor?
In control pannel, select the cursor option..... and then, select ur cursor type.
