What are the challenges you face when working across database platforms? Take the survey
Options

Snippets

MikeONeillMikeONeill Posts: 131
edited February 15, 2010 8:57AM in SQL Prompt Previous Versions
I was just making a snippet

SELECT TOP 10 * FROM $CURSOR$
ORDER BY ... DESC

2 questions

1 - Is there any other $xxxx$ insert other than CURSOR

2 - Can something automatically open the Candidate List at the cursor point (at the moment it seems I have to cnt Space )

As a Suggestion how about multiple Cursor points and TAB between them say , with opening candidate lists as well of course (yes I am lazy !! :D )

SELECT TOP 10 * FROM $CURSOR$
ORDER BY $CURSOR$ DESC

Mike

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    1. Yes you can use $Date$.

    2. It is not possible at present I have logged a feature request (SP-2916) in our internal tracking system.

    Kindly let me know if you need more help on this.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.