MS SQL Server Joins Question: Download Questions PDF
We need to perform what steps in the following order to work with a cursor?
![SQL Server Joins Interview Answer SQL Server Joins Interview Question](https://globalguideline.com/public/images/interview/28.png)
Answer:
☛ Declare cursor
☛ Open cursor
☛ Fetch row from the cursor
☛ Process fetched row
☛ Close cursor
☛ Deallocate cursor
☛ Open cursor
☛ Fetch row from the cursor
☛ Process fetched row
☛ Close cursor
☛ Deallocate cursor
Download SQL Server Joins Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain Cursor as data base object? | Explain collation? |