![]() This cursor contains a snapshot of the first 1000 records from the Sales table. SQL Server INSENSITIVE cursor DECLARE M圜ursor INSENSITIVE CURSOR ![]() ![]() They do create a ‘snapshot’ of the existing data in tempdb when the cursor is declared. Insensitive cursors can’t make changes to underlying tables. An insensitive cursor is used in SQL Server when you want to perform cursor work on data without being affected by changes happening in the underlying table while the query is executing.
0 Comments
Leave a Reply. |