Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandeep
Cursor is a database object even it is treated like a data
type. It is generally used for fast and resource efficient
programming. Cursor wont fetch all datas resulted from a
select statement. Only one row at a time. this speeds up
the population of the data. In select statement all datas
shud be fetched to the client machine. Few drawbacks are
there with cursor but in some cases it works well.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get nth highest salary from employee table.
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How many clustered indexes there can be on table ?
When do you think a developer should use sql server-based cursors?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is an execution plan? When would you use it?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Relational calculus is what type of language?
Can we write ddl in trigger?
What is co-related sub query?
How to specify the collation for a character data type in ms sql server?
Tell me about joins in database system and explain each in detail.
Where is trigger in sql server?
Explain the difference between primary keys and foreign keys?
Name few of the dcl commands in sql?
