In this article, we’ll focus on Transact-SQL cursors. SQL Server supports 3 different implementations of cursors – Transact-SQL cursors, API cursors, and Client cursors. The data model we’ll be using is the same one we’re using throughout this series. Today, while explaining cursors, we’ll use the data from the database to show when (not) to use cursors. That was odd, but that should become much clearer now. In the previous article, Intro to SQL Server loops, we talked about SQL Server loops, but we haven’t used data from the database. Today, we’ll also talk about them and answer the question when (not) to use them. You’ll find different opinions when to use them and when not to do it. SQL Server cursors are one common topic on the Internet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |