November 28, 2018 at 8:53 am
Hi again,
I've done a little research but it seems I might be using the wrong vocabulary to search. I'm tired of typing 'select <field names> from'. It'd be great if I could do something like hit CTRL+1 to spit that out so I can just add the desired tables, joins, fields, etc. Is there anyway to do this? I have looked at the MS article 'SSMS Keyboard Shortcuts' but I can't seem to find what I'm looking for and it even seems that some of the 2008R2 commands aren't working (maybe I'm just misusing them).
Any guidance?
Thanks!
November 28, 2018 at 10:36 am
You should stop using SSMS for 208R2. Download SSMS 17.9, which is free and will work fine for SQL Server 2008 R2.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
Second, I'm guessing you want some sort of template here. It's not perfect, but you can drag/drop templates for code onto a query window: https://docs.microsoft.com/en-us/sql/ssms/tutorials/templates-ssms?view=sql-server-2017
If you want to have something more keyboard driven, the only things that I know to do this are third party tools, such as SQL Prompt. Most cost money, but there may be add-ins that are free.
Disclosure: I work for Redgate Software
November 29, 2018 at 6:00 am
Thanks, Steve!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply