Activity overview
Latest activity by massybird
hawk,
feel free to add to this list: http://www.red-gate.com/MessageBoard/vi ... php?t=4310 / comments
hawk,
feel free to add to this list:http://www.red-gate.com/MessageBoard/vi ... php?t=4310
More improvements:
- currently, you allow only one use of $CURSOR$, it would be fantastic if a snippet could contain more than one cursor position markers, so you could jump to each one in order that they appear with the use of the ENTER key; that is, type in code for first cursor, press ENTER to move to second cursor marker, type in code for second cursor, press ENTER... etc.
- a shortcut key to jump to definition of a stored procedure when the cursor is on any part of the stored procedure name within a file - opens new window with stored procedure definition as it exists in the database
- snippet import/export, i.e. template files, as suggested here: http://www.red-gate.com/MessageBoard/vi ... php?t=4230 / comments
More improvements:
- currently, you allow only one use of $CURSOR$, it would be fantastic if a snippet could contain more than one cursor position markers, so you could jump to each one in order th...
The only thing I would add to your snippet would be:
UPDATE $CURSOR$ SET
so the cursor is positioned right after the UPDATE keyword when SQL Prompt resolves the snippet. That way you avoid moving the cursor yourself to type in the name of the table you're updating. Good suggestion on import/export of snippets. / comments
The only thing I would add to your snippet would be:
UPDATE $CURSOR$ SET
so the cursor is positioned right after the UPDATE keyword when SQL Prompt resolves the snippet. That way you avoid moving ...
SQL Prompt 3 Improvements Suggestions
Here are some suggestions for improving SQL Prompt (pardon if some are repeats of previous suggestions):
- smart(er) indenting of code/script
- ability to format an entire script with a hot-key sho...