Skip to content

SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

2 results found

  1. Hi support,

    Please add TRY_CAST to you list of key words in SQL Prompt.

    Best regards,

    Henrik

    Henrik Staun Poulsen

    Vestas Data Center

    Vestas Technology R&D

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    declined  ·  Aaron Law responded

    Hi Henrik,

    Unfortunately the script syntax highlighting is not handled by SQL Prompt. It’s something that’s built into SSMS and so we don’t have control over which keywords get marked as pink.

  2. When writing statements like 'ssf s [tab] [enter]' to produce the statement in exhibit A based on the prompt suggestions, the alias 's' gets interpreted as another shortcut for additional keywords as seen in exhibit B. It would be nice if SQL Prompt was aware of its own shortcuts and produced some other unique alias so it didn't collide and create parser errors

    --Exhibit A
    SELECT * FROM config.Service AS S

    --Exhibit B
    SELECT * FROM config.Service AS SELECT

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    declined  ·  Aaron Law responded

    I’m going to close this request because it looks like this was only an issue when the SSMS Tools Pack was installed – the solution was to disable snippets in the tools pack. If you’re still having problems with its snippets disabled then let me know.

  • Don't see your idea?