This article describes SQL cursors and how to use them for some special purposes. It highlights the importance of SQL cursors along with their downsides.
It is not always the case that you use SQL cursor in database programming, but their conceptual understanding and learning how to use them helps a lot to understand how to perform exceptional tasks in T-SQL programming.
SQL Cursors Overview
Let us go through some basics of SQL cursors if you are not familiar with them.