CURSOR
Translation reference to convert SQL Server CUROR statement to Snowflake Scripting
Some parts in the output code are omitted for clarity reasons.
Description
Microsoft SQL Server statements produce a complete result set, but there are times when the results are best processed one row at a time. Opening a cursor on a result set allows processing the result set one row at a time. You can assign a cursor to a variable or parameter with a cursor data type. For more information check here.
Sample Source Patterns
SQL Server
Notice that the following parameters are inherently supported by Snowflake Scripting.
[LOCAL].
[FORWARD_ONLY].
[FAST_FORWARD] Specifies a FORWARD_ONLY (FETCH NEXT only) and READ_ONLY
[READ_ONLY] the WHERE CURRENT OF does not exist in Snowflake Scripting.
IN -> SqlServer_01.sql
Snowflake Scripting
OUT -> SqlServer_01.sql