dot Net Database Question: Download Questions PDF
Explain What are cursors? Name four type of cursors and when each one would be applied?
Answer:
Opening a cursor on a result set allows processing the result set one row at a time.
The four API server cursor types supported by SQL Server are:
a) Static cursors
b) Dynamic cursors
c) Forward-only cursors
d) Keyset-driven cursors
The four API server cursor types supported by SQL Server are:
a) Static cursors
b) Dynamic cursors
c) Forward-only cursors
d) Keyset-driven cursors
Download dot Net Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain How many objects are there in ASP? | Explain What is the STUFF function and how does it differ from the REPLACE function? |