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

SQL Prompt Snippet produces different output when selecting with Mouse vs ENTER key

sajjansajjan Posts: 4 Bronze 1
edited February 20, 2018 5:39PM in SQL Prompt

Here is the original snippet code:
SELECT top 10 * from $CURSOR$ order  by desc

When i select the snippet using the mouse i get this (this is correct):
SELECT top 10 * from  order  by desc
When I select the same snippet using the ENTER key i get this:
select * from


SQL Prompt Log At Time of Snippet Typing:

System Details:
SQL Prompt version: and
OS: Windows 7
SQL Server: 2014

Best Answers

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Answer ✓
    Hi @sajjan

    Thanks for highlighting this issue.

    As we discussed in the ticket, upgrading to the latest version ( - May 9th 2018) of SQL Prompt and recreating the snippet seem to have resolved the issue.

    Please do let us know if it reoccurs.

    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    sajjansajjan Posts: 4 Bronze 1
    Root cause of the error was that I had another SSMS add-in called SSMSBoost which also had a template called "sel" , so when I typed "sel" and hit enter it was giving priority to the SSMSBoost snippet over SQL Prompt.

    Deleting the snippet from SSMSBoost made it work.


Sign In or Register to comment.