tag:blogger.com,1999:blog-596112675619409125.post213077238767513705..comments2024-03-18T16:06:57.064-07:00Comments on SQL Server Techniques: SSMS Query ShortcutsSlava Muryginhttp://www.blogger.com/profile/11665340455730972723noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-596112675619409125.post-31109452909630835172022-11-17T14:31:29.640-08:002022-11-17T14:31:29.640-08:00Top of that page -> Favorite Links -> SSMS Q...Top of that page -> Favorite Links -> SSMS Query ShortcutsSlava Muryginhttps://www.blogger.com/profile/11665340455730972723noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-82024614991882169842022-11-15T04:14:07.124-08:002022-11-15T04:14:07.124-08:00Where is the powershell script? Cannot find it.Where is the powershell script? Cannot find it.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-43891082669736623102020-08-08T02:02:20.293-07:002020-08-08T02:02:20.293-07:00Excellent one!Excellent one!Mani G S.https://www.blogger.com/profile/15055093593281646247noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-75879775104855740882018-08-08T07:28:34.787-07:002018-08-08T07:28:34.787-07:00Also useful:
Ctrl+K+C/U - comment/uncomment select...Also useful:<br />Ctrl+K+C/U - comment/uncomment selected lines<br />Alt+X/Ctrl+E - Execute query. Alt+X is the most used by me<br /><br />Custom bindings - I use select top (1000) * from <br />, select count(*) from <><br />, select <> -- that's for functions<br />, most often queries, for example obtaining the dictionary value for some ID (i.e. object_name(@object_id)), getting time from unix timestamp, etc<br />Sergey Zenzinovhttps://www.blogger.com/profile/17276417805696168589noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-59457631611323726042017-02-08T13:00:13.958-08:002017-02-08T13:00:13.958-08:00Can you try the solution I put in a blog post?
htt...Can you try the solution I put in a blog post?<br />http://slavasql.blogspot.com/2017/02/fixing-hot-key-issue-in-ssms-in-five.html<br />Slava Muryginhttps://www.blogger.com/profile/11665340455730972723noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-39918430641756611442017-02-08T10:34:12.245-08:002017-02-08T10:34:12.245-08:00CTRL-D vanished from one version of SSMS, then see...CTRL-D vanished from one version of SSMS, then seemed to come back for a while, and now is gone again. Similarly, CTRL-SHIFT-L deletes a line rather than lower-casing a highlighted bit of text. I haven't been doing any updates in between (the last update made the C-D/C-S-L vanish, I don't know WHAT brought them back, and they are gone again after we moved to a new network domain & profile) -- is there a setting for these I'm just not seeing?Russ Perry Jrhttps://www.blogger.com/profile/04220637949350034056noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-15850173711377686912016-07-29T12:41:06.672-07:002016-07-29T12:41:06.672-07:00You just have to highlight your table name and the...You just have to highlight your table name and then press Ctrl-F1. If you want to specify fully qualified table name with schema name you have to put it in single quotes and highlight it all together. (For instance: --> 'dbo.tbl_TestMe' <-- )Slava Muryginhttps://www.blogger.com/profile/11665340455730972723noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-24323749245509934702016-07-29T11:02:47.579-07:002016-07-29T11:02:47.579-07:00Using Ctrl_F1 as an example, how do I pass a param...Using Ctrl_F1 as an example, how do I pass a parameter to the keyboard shortcut when I am actually pressing the ctrl and F1 keys?Anonymoushttps://www.blogger.com/profile/05729043099404054276noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-22692552752102310252016-02-20T22:18:46.462-08:002016-02-20T22:18:46.462-08:00Thank you so much Thank you so much Anonymoushttps://www.blogger.com/profile/07376402737344841731noreply@blogger.comtag:blogger.com,1999:blog-596112675619409125.post-54014773974536825072016-02-15T17:46:33.286-08:002016-02-15T17:46:33.286-08:00good one
good one<br />Avadhoothttps://www.blogger.com/profile/02796677573105432908noreply@blogger.com