How is SQL Prompt helping your team? Share your experience.
annoying bug

in SQL Prompt
Hi redgate Team,
there is an annoying bug which makes it hard to use SQL Prompt.
Bug:
1) Create a snippet and call the snippet #JobCategory for example
2) Type GO into SSMS and press enter,
3) SQL Prompt inserts the code for the snippet instead of GO
Fix:
Make sure that you have to type the name of the snippet or at least the first!! characters to insert the snippet. GO is part of #JobCate!go!ry but apart from this there is nothing in common.
Please fix this since once the snippet is inserted you cannot even undo it by pressing CTRL+Z.
Thanks!
Torsten
there is an annoying bug which makes it hard to use SQL Prompt.
Bug:
1) Create a snippet and call the snippet #JobCategory for example
2) Type GO into SSMS and press enter,
3) SQL Prompt inserts the code for the snippet instead of GO
Fix:
Make sure that you have to type the name of the snippet or at least the first!! characters to insert the snippet. GO is part of #JobCate!go!ry but apart from this there is nothing in common.
Please fix this since once the snippet is inserted you cannot even undo it by pressing CTRL+Z.
Thanks!
Torsten

Tagged:
Answers
Dan Jary | Redgate Software
Have you visited our Help Center?
It seems that you first have to enter #J and select the snippets attached. Once SQL Prompt "registered" the snippet it will sugest and insert the content of the snippet everytime you enter GO then.
Dan Jary | Redgate Software
Have you visited our Help Center?
I know this post is quite old but I am experiencing the same issues;
basically if a snippet has a substring of a SQL statement, then once you hit enter (or one of the keys to activate the snippet), then it'll paste it in
For example, I could write
LEFT JOIN TABLE1
ON
then I have a snippet called Addons (ON is inside Addons) so it shows up as an option, so if I want a new line I hit return, but it enters the snippet..
Before I go and rename all snippets, is there a workaround? I feel like there should a key that allows you to bring up snippets, for example a "!" key, then once I start typing it should show my snippet list in the tool tip, not when I am typing normal SQL code, otherwise it auto completes every time I try and write a JOIN.
I can try and create a gif or something if that helps you visualise but hopefully that information is enough?
Thanks!