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.
What else can I help you with?
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 difference between overtype mode and insert mode?
The only difference between Insert Mode and Overtype Mode is that characters are placed in front of the text after the cursor in Insert Mode, where as existing characters are overwritten in Overtype Mode.
What is the basic terminology of dbms?
Acid cursor data database field primary & foreign keys procedure & function odbc & oledb normalization trigger
How do you know when over-type mode is on?
You can tell when over-type mode is on by observing the cursor behavior in a text editor or word processor. Instead of the usual vertical blinking line, the cursor typically changes to a different shape, such as a block or solid rectangle. Additionally, when you type, existing text will be overwritten rather than pushed to the right, which is a clear indicator that over-type mode is active.
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)
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.
How do you put SQL Server in hot backup mode?
Use the TSQL backup command to backup an active database.
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.
Why is the computer cursor called the cursor?
Its ugly
What part of speech is cursor?
"Cursor" is a noun.
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.
Does Sims 3 pets have a cursor?
Yes of course it has a cursor. All of the Sims 3 games have a cursor.
