The coverage of a cursor label
2 , LOCAL and GLOBAL, LOCAL cursor name that contains the affirm cursor statement is merely stored procedure , trigger,
Lacoste Shoes, or batch athletic ( namely is,
Lacoste Camden Trainers, in the stored program , trigger,
Lacoste, alternatively batch can no be outside Access to the cursor name ), GLOBAL cursor name that the global forcible ( as long as the implementation of the declare cursor statement, deallocate statement in the implementation of suitable , any place can access the cursor name .)
scope of the cursor name can be specified in the declare cursor time , that the use declare CursorName cusor LOCAL | GLOBAL because ... to specify the scope of the cursor is LOCAL or GLOBAL,
Lacoste Running Trainers, if I were you specified in the declare cursor while the scope is The cursor from the database using the domain adoption default to local cursor setting to control , this discretion is disloyal, the default is that the cursor scope is GLOBAL,
Buy Lacoste Trainers, otherwise, LOCAL, in SQL SERVER 2000 ,
Lacoste Swerve Lace Trainers, this alternative is the default worth false, in array to match the earlier SQL SERVER ( the subject of one earlier version of the scope of the middle approaches are GLOBAL).
adjust the database culling can be processed using the following statement
vary database DBName set CURSOR_DEFAULT LOCAL | GLOBAL