DF184: SQL-92 style cursor declaration is used.

Last modified: December 25, 2024

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

Category

BEST PRACTICE

Message

SQL-92 style cursor declaration is used.

Description

For improved compatibility with the latest versions of Microsoft SQL Server and better performance, it is recommended to use T-SQL cursor declaration format instead of SQL-92 style.

Noncompliant code example

DECLARE cursor_name INSENSITIVE SCROLL CURSOR
FOR select id from dbo.DemoTable

Compliant solution

DECLARE cursor_name CURSOR LOCAL SCROLL
FOR select id from dbo.DemoTable
GO