Answer Posted / nisha
Cursor is a programming device that allows the SELECT to
find a set of rows but return them one at a time. Cursor
should be used because the host language can deal with only
one row at a time.
you can get unlimited interview questions on:
http://www.interviewhelper.org
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between char, varchar and nvarchar?
Why should you use or avoid select * statements?
What is attribute hierarchy? : sql server analysis services, ssas
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Is sql different from sql server?
Does a sql server 2005 select statement require a from?
what method you can use to reduce the overhead of Reporting Services data sources?
Is INSTEAD OF trigger directly applicable to Table ?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
Can we update data in a view?
What is the need for indexing?
How to use subqueries with the exists operators in ms sql server?
How to sort the query output with order by clauses in ms sql server?
Explain isolation levels that sql server supports?
What is the difference between NOROW and LOCKROW?