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
Explain collation?
What is join query?
What is public role in sql server?
Which are ddl commands?
Explain various data region available in ssrs with their use?
What is the maximum size of a row in sql server?
What are diverse clauses that form a part of sql?
What is difference between delete and truncate commands?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What are the differences between DDL, DML and DCL in SQL?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is filestream?
What objects does the fn_my_permissions function reports on? : sql server security
What are the properties of the transactions?
How to use old values to define new values in update statements in ms sql server?
