How can we help you today? How can we help you today?

Auto insert for "SELECT COUNT(*) FROM"

How can I put in an auto insert for "SELECT COUNT(*) FROM". When I enter this in as my snippet it returns "SELECT COUNT* FROM" in the test box. Is there an escape character for the parenthesis?

Will I be able to do this in V3 when it releases?

Tim
Denver, CO
tgoldstein
0

Comments

2 comments

Sort by
  • Tilman
    Hi,

    Please see this thread for your answer regarding SQL Prompt 2:

    http://www.red-gate.com/messageboard/vi ... php?t=2554

    In SQL Prompt 3 you will be able to enter the snippets without having to escape any characters.

    Regards,

    Tilman
    Tilman
    0
  • tgoldstein
    Thank you. Using the {} to bracket the ( and ) did the job as explained in the post.

    Tim
    Denver, CO
    tgoldstein
    0

Add comment

Please sign in to leave a comment.