Activity overview
Latest activity by muellerbill
Here's a snippet which creates some boilerplate cursor code:
name: cur
snippet:
DECLARE /* VARIABLES */
DECLARE <CURSOR> CURSOR FAST_FORWARD READ_ONLY FOR
/* SELECT STATEMENT */
OPEN <CURSOR>
FETCH NEXT FROM <CURSOR> INTO /* VARIABLES */ @FETCH_STATUS = 0
BEGIN
/* CURSOR LOGIC */
FETCH NEXT FROM <CURSOR> INTO /* VARIABLES */
END
CLOSE <CURSOR>
DEALLOCATE <CURSOR>
In a perfect world, the Replace dialog would display with <CURSOR> as the text to replace.
Regards / comments
Here's a snippet which creates some boilerplate cursor code:
name: cur
snippet:
DECLARE /* VARIABLES */
DECLARE <CURSOR> CURSOR FAST_FORWARD READ_ONLY FOR
/* SELECT STATEMENT */
OPEN <CURSOR>
FETCH...