Skip to content
← SQL Prompt

How can we improve SQL Prompt?

'Add $PASTE$ to paste current clipboard text into a snippet' has been merged into this idea

SQL Prompt

Categories

Create more $...$ placeholders for snippets

I would like to see additional placeholders for the snippet manager. For example $DBNAME$, $SERVER$, $PASTE$ (already suggested). A format option for $DATE$ and $TIME$ would also be nice (e.g. $DATE(mm/dd/yyyy)$ $TIME(hh:mm:ss24/hh:mm:ssA/hh:mm)$, etc.).

39 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Doug shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jermy commented  ·   ·  Report

    Also $SELECTED$ to be replaced with the current selected text in editor

  • Doug commented  ·   ·  Report

    Acutally, the intent would be when the saved snippet was brought into SSMS, any $(PASTE) placeholder in the snippet would be replaced by the contents of the clipboard. Thus if I had a snippet with the code:

    SELECT ITEM, SUM($PASTE$) AS $PASTE$
    FROM myTable
    GROUP BY ITEM
    HAVING $PASTE$ > 0

    defined as 'si', if I copied 'JanuarySales' into the clipboard and expanded the snippet 'si', it would expand as
    SELECT ITEM, SUM(JanuarySales) AS JanuarySales
    FROM myTable
    GROUP BY ITEM
    HAVING JanuarySales > 0

  • Doug commented  ·   ·  Report

    I've been clipped in my ars a time or two :-)

  • jbelina commented  ·   ·  Report

    This would be great, especially if you could do something like:

    sum($PASTE$) as $PASTE$

    So that you could cut out a column name MyColumn out of a select list and replace it with sum(MyColumn) as MyColumn...

  • Doug commented  ·   ·  Report

    YES! YES! YES! I've suggested this in the past.