June 20, 2017 at 10:34 am
Does anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 20, 2017 at 10:40 am
Sean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.
Ctrl-Shift-P for SQLPrompt (enable suggestions in the menu). Not sure about the native.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2017 at 10:45 am
Sean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.
Not sure how to disable intellisense.
But when I have to do something like add and @ to a long list of paramaters, I
June 20, 2017 at 10:55 am
DesNorton - Tuesday, June 20, 2017 10:45 AMSean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.Not sure how to disable intellisense.
But when I have to do something like add and @ to a long list of paramaters, I
- Align all the parameters
- Position my mouse pointer at the start of the parameter list
- ALT-Click, and drag the mouse to the end of the list
- Type the @
- Click elsewhere ....
Exactly what I was about to suggest, AKA block editing.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 20, 2017 at 10:55 am
DesNorton - Tuesday, June 20, 2017 10:45 AMSean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.Not sure how to disable intellisense.
But when I have to do something like add and @ to a long list of paramaters, I
- Align all the parameters
- Position my mouse pointer at the start of the parameter list
- ALT-Click, and drag the mouse to the end of the list
- Type the @
- Click elsewhere ....
OMG this is brilliant. I had no idea you could do this. Just saved me 20 minutes of agonizing keystrokes. Thanks!!! No need to disable intellisense at all.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 20, 2017 at 11:00 am
Sean Lange - Tuesday, June 20, 2017 10:55 AMDesNorton - Tuesday, June 20, 2017 10:45 AMSean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.Not sure how to disable intellisense.
But when I have to do something like add and @ to a long list of paramaters, I
- Align all the parameters
- Position my mouse pointer at the start of the parameter list
- ALT-Click, and drag the mouse to the end of the list
- Type the @
- Click elsewhere ....
OMG this is brilliant. I had no idea you could do this. Just saved me 20 minutes of agonizing keystrokes. Thanks!!! No need to disable intellisense at all.
You can also do the above but instead of the mouse you can do SHIFT+ALT+DownArrow if you start with the first parameter at the top of the list or SHIFT+ALT+UpArrow if you start at the bottom of the parameter list.
June 20, 2017 at 11:02 am
I use the ALT trick often.
Hold Shift+ALT and you can make a vertical selection. by downarrowing. You can type something in there. ALT+Click works with the mouse.
June 20, 2017 at 12:16 pm
Steve Jones - SSC Editor - Tuesday, June 20, 2017 11:02 AMI use the ALT trick often.Hold Shift+ALT and you can make a vertical selection. by downarrowing. You can type something in there. ALT+Click works with the mouse.
Being a keyboard guy I prefer this but honestly either one is a huge time saver. Gosh I feel so embarrassed I didn't know this was possible.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 20, 2017 at 12:37 pm
Sean Lange - Tuesday, June 20, 2017 12:16 PMBeing a keyboard guy I prefer this but honestly either one is a huge time saver. Gosh I feel so embarrassed I didn't know this was possible.
Don't be. It came in VS, and I learned it years ago (2010? 2012?), but forgot. I had to look it up, but not I'll use it to move commas periodically and then remember it. It feels more useful in C# than T-SQL, but maybe that's me.
June 20, 2017 at 12:45 pm
GilaMonster - Tuesday, June 20, 2017 10:40 AMSean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.Ctrl-Shift-P for SQLPrompt (enable suggestions in the menu). Not sure about the native.
I don't believe there's a shortcut for it in native SSMS. It's an option under Text Editor...Transact-SQL...IntelliSense.
June 20, 2017 at 12:48 pm
Steve Jones - SSC Editor - Tuesday, June 20, 2017 12:37 PMSean Lange - Tuesday, June 20, 2017 12:16 PMBeing a keyboard guy I prefer this but honestly either one is a huge time saver. Gosh I feel so embarrassed I didn't know this was possible.
Don't be. It came in VS, and I learned it years ago (2010? 2012?), but forgot. I had to look it up, but not I'll use it to move commas periodically and then remember it. It feels more useful in C# than T-SQL, but maybe that's me.
I use it all the time and love it. It's one of the great time-savers. It also lets you select a "column" of 0 characters wide.
June 20, 2017 at 1:00 pm
Ed Wagner - Tuesday, June 20, 2017 12:45 PMGilaMonster - Tuesday, June 20, 2017 10:40 AMSean Lange - Tuesday, June 20, 2017 10:34 AMDoes anyone know how to disable the intellisense in sql prompt? I only want to do this temporarily. I have a very long list of parameters and I need to add an @ at the beginning of a LOT of lines. Being forced to hit escape each line is really obnoxious. It would be really spectacular if there was a feature to temporarily completely disable all intellisense both sql prompt and the native one.Ctrl-Shift-P for SQLPrompt (enable suggestions in the menu). Not sure about the native.
I don't believe there's a shortcut for it in native SSMS. It's an option under Text Editor...Transact-SQL...IntelliSense.
Mine works with Ctrl+Q,Ctrl+I
June 20, 2017 at 1:12 pm
Sean Lange - Tuesday, June 20, 2017 10:55 AMOMG this is brilliant. I had no idea you could do this. Just saved me 20 minutes of agonizing keystrokes. Thanks!!! No need to disable intellisense at all.
I cover this (and more) in my presentation at the 2016 PASS Summit. You can see it at http://www.pass.org/Learning/Recordings/Listing.aspx?category=conferences# - Just search for "SSMS".
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 20, 2017 at 1:23 pm
Steve Jones - SSC Editor - Tuesday, June 20, 2017 12:37 PMSean Lange - Tuesday, June 20, 2017 12:16 PMBeing a keyboard guy I prefer this but honestly either one is a huge time saver. Gosh I feel so embarrassed I didn't know this was possible.
Don't be. It came in VS, and I learned it years ago (2010? 2012?), but forgot. I had to look it up, but not I'll use it to move commas periodically and then remember it. It feels more useful in C# than T-SQL, but maybe that's me.
As a dotnet guy I feel I should have known this. I have actually used this trick about 7-8 times already in t-sql within the last couple hours.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 20, 2017 at 4:07 pm
Sean Lange - Tuesday, June 20, 2017 1:23 PMSteve Jones - SSC Editor - Tuesday, June 20, 2017 12:37 PMSean Lange - Tuesday, June 20, 2017 12:16 PMBeing a keyboard guy I prefer this but honestly either one is a huge time saver. Gosh I feel so embarrassed I didn't know this was possible.
Don't be. It came in VS, and I learned it years ago (2010? 2012?), but forgot. I had to look it up, but not I'll use it to move commas periodically and then remember it. It feels more useful in C# than T-SQL, but maybe that's me.
As a dotnet guy I feel I should have known this. I have actually used this trick about 7-8 times already in t-sql within the last couple hours.
Does it sound weird that I learned it in SSMS before even trying it in .NET? 😉
Viewing 15 posts - 58,951 through 58,965 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply