INSERT - SELECT formatting issues w/ SQL Prompt 6.x

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

INSERT - SELECT formatting issues w/ SQL Prompt 6.x

Postby paschott » Fri Jun 06, 2014 6:57 pm

I'm trying to format my INSERT / SELECT code and when I use CTRL+K+Y, my SELECT statement gets indented under the INSERT like so:

Code: Select all
INSERT   dbo.MyTable
      ( MyTableName
      , Description
      )
      SELECT   '' AS MyTableName
           , '' AS Description


I would normally expect the SELECT portion to align with the INSERT, but can't seem to find the formatting option that would do this in SQL Prompt. Can anyone point me in the right direction or does this need to be a new feature request?
paschott
 
Posts: 64
Joined: Wed May 10, 2006 4:10 pm

Postby Aaron Law » Mon Jun 09, 2014 11:12 am

Hi Peter,

We've updated the beta to format SELECT/INSERT like this, to get this build see our forum post here.

Thanks,
Aaron.
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby paschott » Mon Jun 09, 2014 5:28 pm

Thanks, Aaron. Downloading the updated beta now.
paschott
 
Posts: 64
Joined: Wed May 10, 2006 4:10 pm

Postby Aaron Law » Mon Jun 23, 2014 3:11 pm

Hi Peter,

We've moved this to an option in the latest beta (it's off by default so as not to affect anyone who was expecting the old style as happened with Jim) which can be found under Format->Data statements->Align SELECT with INSERT
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby paschott » Mon Jun 23, 2014 4:49 pm

Thanks, Aaron. I was kind of expecting it to be an option because of something like this. I appreciate having the choice. :)
paschott
 
Posts: 64
Joined: Wed May 10, 2006 4:10 pm


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests