Settings and activity
11 results found
-
1 vote
An error occurred while saving the comment An error occurred while saving the comment 
Sean Redmond
commented
This is true.
At the moment, auto-completion has become useful but it means that the snippets are relegated in importance. They only useful in the databases whose snippets I have defined and I have to constantly think about similarly named tables from other databases.
The snippets are fast though and I don't think that it would be that great a change to introduce this change. One would need a tree structure in the snippets folder and code to tell SQL Prompt which leaf folder to use.Sean Redmond
shared this idea
·
-
1 voteSean Redmond
shared this idea
·
-
6 votesSean Redmond
supported this idea
·
-
5 votesSean Redmond
supported this idea
·
-
6 votesSean Redmond
supported this idea
·
-
6 votesSean Redmond
supported this idea
·
-
3 votesSean Redmond
supported this idea
·
-
10 votesSean Redmond
supported this idea
·
-
2 votes
An error occurred while saving the comment Sean Redmond
commented
Have an option to replace -- (on a line by line basis) with /**/ at the beginning & end of the selected text when the «Comment out lines» command/button in SSMS is chosen/pressed.
The idea came to mind after watching this Brent Ozar video:
https://www.brentozar.com/archive/2021/04/never-ever-ever-start-t-sql-comments-with-two-dashes/Sean Redmond
supported this idea
·
-
4 votesSean Redmond
shared this idea
·
-
2 votesSean Redmond
supported this idea
·
Auto-completion is what I use at the moment but it distracts from the power of snippets. With snippets I am able to type in, say, pe and dbo.persons comes up but this becomes a problem when I am using those databases that I venture less frequently into.
The auto-complete is good but it slows me down in that I have to consider what the correct variant that I want is.
If snippets could be made database-dependent, then I could simply define one set of snippets per database and then not have to think about whether I have the right persons table or not.