Skip to content

Instantly share code, notes, and snippets.

@kenny-evitt
Created October 3, 2017 14:14
Show Gist options
  • Save kenny-evitt/d60d501f60a36e5ca29f98be99634848 to your computer and use it in GitHub Desktop.
Save kenny-evitt/d60d501f60a36e5ca29f98be99634848 to your computer and use it in GitHub Desktop.
T-SQL cursor template
DECLARE @columnValue int;
DECLARE cursor_ CURSOR LOCAL
FORWARD_ONLY
FAST_FORWARD
READ_ONLY
FOR
SELECT Column
FROM dbo.Table;
OPEN cursor_;
FETCH cursor_ INTO @columnValue;
WHILE @@FETCH_STATUS = 0
BEGIN
-- Do something with `@columnValue`
FETCH cursor_ INTO @columnValue;
END
CLOSE cursor_;
DEALLOCATE cursor_;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment