![]() ![]() The cursor can be limited for use within the given stored procedure, trigger or batch making it a LOCAL cursor. Examples of such scenarios are when cascading complex calculations need to happen for each record (which are handled via CLR code or dedicated stored procedures) or when interfacing applications can only accept one record at a time.Įach T-SQL cursor has a specific scope. At the same time, there are applications where one simply cannot use a set-based approach and use T-SQL cursors. ![]() It’s a well-known fact that using T-SQL cursors have a significant overhead on the query performance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |