Hectic Key Combination Shortcuts (Ctrl+K and ++)!
-
[font="Verdana"]Hi SSC,
Its toooooo hectic to press key combinations twice for basic operation of Commenting/un-Commenting code etc. 🙁
I have noticed that until the current SQL Server release 11, we were still able to set keyboard shortcuts with the compatibility of SQL Server 2000. But now this facility has gone, at least for SQL Server 11 Developer Edition!
Any shortcut to shortcut this huge pitfall will be highly appreciated ..... Please! :crying: :crying: ...
Many thanks![/font]
-
I've got 2012, and it looks to me like i can assign or replace keyboard shortcuts no problem.
Tools>> Options>> Keyboard might have a slightly different layout, but it's there for me.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowell (8/7/2012)
I've got 2012, and it looks to me like i can assign or replace keyboard shortcuts no problem.Tools>> Options>> Keyboard might have a slightly different layout, but it's there for me.
[font="Verdana"]
Yep, great help! The interface is also available to me, but this kind of configuration is very new for me, with background of SSMS (SQL SERVER) only.
But as far i have studied about this problem this will create a New Global Shortcut, which has its own .. scope etc? is this factor also important or may cause any inconvenience?
[/font]
-
[font="Verdana"]Lowell, your support was superb, but is there any solution to the following new issue :doze:
That in previous releases i can define shortcut keys for my own purpose as well
like
the command text "Exec sp_helptext " or "SELECT TOP 30 * FROM " was configured with some key combination and ... after selecting some procedure name from the text editor, i can execute this command and never felt the need to write the code segment again and again...!!!
Please help, how can i achieve the same in new environment? [/font]
-
Abrar Ahmad_ (12/18/2012)
[font="Verdana"]Lowell, your support was superb, but is there any solution to the following new issue :doze:That in previous releases i can define shortcut keys for my own purpose as well
like
the command text "Exec sp_helptext " or "SELECT TOP 30 * FROM " was configured with some key combination and ... after selecting some procedure name from the text editor, i can execute this command and never felt the need to write the code segment again and again...!!!
Please help, how can i achieve the same in new environment? [/font]
Yes there sure is. You can add your own keyboard shortcuts. I have a suite of commands just like you are refering.
if you use procedures youl want to mark them as system objects.
also you want to remember that the settings are just for the current user / current machinery ne. You have to copy paste the file sql? .bin for the %appdata% folder , or recreate it to get the same settings on laptop vs desktop
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowell (12/19/2012)
Abrar Ahmad_ (12/18/2012)
[font="Verdana"]Lowell, your support was superb, but is there any solution to the following new issue :doze:That in previous releases i can define shortcut keys for my own purpose as well
like
the command text "Exec sp_helptext " or "SELECT TOP 30 * FROM " was configured with some key combination and ... after selecting some procedure name from the text editor, i can execute this command and never felt the need to write the code segment again and again...!!!
Please help, how can i achieve the same in new environment? [/font]
Yes there sure is. You can add your own keyboard shortcuts. I have a suite of commands just like you are refering.
if you use procedures youl want to mark them as system objects.
also you want to remember that the settings are just for the current user / current machinery ne. You have to copy paste the file sql? .bin for the %appdata% folder , or recreate it to get the same settings on laptop vs desktop
Lowell, again a bundle of thanks for your time, and you very rightly got my problem; but for to set these settings in 2012 SSMS, i may request more details from you, a bit more elaborated one 🙁
Thank you in advance!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply