DF010: The scope of a cursor (LOCAL or GLOBAL) is not specified.

Last modified: December 25, 2024

The topic describes the DF010 T-SQL code analysis rule.

Message

The scope of a cursor (LOCAL or GLOBAL) is not specified.

It is recommended to explicitly define the scope of a cursor: LOCAL or GLOBAL.

If neither GLOBAL nor LOCAL is specified, the default value is determined by the default to local cursor database parameter setting.

DECLARE cur CURSOR READ_ONLY FOR
SELECT FirstName FROM dbo.Customers

DECLARE cur CURSOR LOCAL READ_ONLY FOR
SELECT FirstName FROM dbo.Customers

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by SQL Complete.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.