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 set database to be read_only in ms sql server?
What are various limitations of the views?
Explain the dbcc pintable command when would you use it?
How does using a separate hard drive for several database objects improves performance right away?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Where to find ntwdblib.dll version 2000.80.194.0?
What is sub-query in sql server?
Define magic tables in sql server?
How many columns can exist together per table?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What do you need to connect php to sql server?
What are the three different part of rdl file explain them?
How does a profiler work?
Ms sql server index?
Explain differences between web edition and business edition?
