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

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:

INSERT	dbo.MyTable
		&#40; MyTableName
		, Description
		&#41;
		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 June 06, 2014 13:57

Comments

4 comments

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 L June 09, 2014 06:12

0
Thanks, Aaron. Downloading the updated beta now.

paschott June 09, 2014 12:28

0
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 L June 23, 2014 10:11

0
Thanks, Aaron. I was kind of expecting it to be an option because of something like this. I appreciate having the choice.

paschott June 23, 2014 11:49

0

Add comment

Please sign in to leave a comment.

How can we help you today?

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

Comments

Add comment