Share your SQL code snippets for SQL Prompt!
Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson
I've looked within the options panel for a way of exporting snippets but I can't find a way. So I might as well just post it up here in freetext:
I was quite surprised there wasn't one there for UPDATE already actually. Anyway, its in mine now!!!
P.S. Is there a way to export/import snippets?
- Posts: 8
- Joined: Mon Jan 29, 2007 7:00 pm
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.
- Posts: 4
- Joined: Wed Feb 14, 2007 2:41 pm
I tried to set the cursor in my snippet using the $CURSOR$ statement. But upon testing it in the query analyzer, it only showed the text itself. Hope you can help me out.
- Posts: 3
- Joined: Tue Feb 20, 2007 4:03 am
Return to SQL Prompt code snippets
Who is online
Users browsing this forum: No registered users and 0 guests