Possible Formating Bug I found
MattO
Posts: 8
I have the following statment:
Which is on a few lines. If I have refactor do the Layout SQL option it always formats it like this:
I have disabled all the options to prohibit this, and yet it still is persistent on doing a new line for every column/parameter.
You can see screenshots of ALL of my settings here:
http://www.ottechnologies.com/downloads ... ttings.doc
We plan on purchasing this product. Any assistance with this issue would be greatly appreciated.
FYI, I am using SQL 2005 Management Studio.
INSERT INTO TATX1030 (TRX_I, EMPID_I, JOBTITLE, DEPRTMNT, DIVISIONCODE_I, TIMECODE_I, TRXDATE, HOURS_I, ACCFLG, ATTTYP, ATTRSN, ATTTRXSTATUS, PAYRCORD, CHANGEBY_I, CHANGEDATE_I, CHANGETIME_I) VALUES (@nextTrxID,@empID,@jobtitle,@Deprtmnt,@divisionCode,@timecode,@currentDate,@hoursToAdjust, 1,@type,@reason, 5,@paycode, LEFT(SUSER_NAME(), 15),@currentDate,@currentTime)
Which is on a few lines. If I have refactor do the Layout SQL option it always formats it like this:
INSERT INTO TATX1030 ( TRX_I, EMPID_I, JOBTITLE, DEPRTMNT, DIVISIONCODE_I, TIMECODE_I, TRXDATE, HOURS_I, ACCFLG, ATTTYP, ATTRSN, ATTTRXSTATUS, PAYRCORD, CHANGEBY_I, CHANGEDATE_I, CHANGETIME_I ) VALUES ( @nextTrxID, @empID, @jobtitle, @Deprtmnt, @divisionCode, @timecode, @currentDate, @hoursToAdjust, 1, @type, @reason, 5, @paycode, LEFT(SUSER_NAME(), 15), @currentDate, @currentTime )
I have disabled all the options to prohibit this, and yet it still is persistent on doing a new line for every column/parameter.
You can see screenshots of ALL of my settings here:
http://www.ottechnologies.com/downloads ... ttings.doc
We plan on purchasing this product. Any assistance with this issue would be greatly appreciated.
FYI, I am using SQL 2005 Management Studio.
Comments
I'm afraid I don't know if this is a bug or a design issue. I'll get an answer for you shortly.
Thanks for reporting this: this is indeed an inconsistency in the way this option is implemented at present. I've added this to our bug tracking system for fixing in a future release.
Andrew.
Software Developer
Red Gate Software Ltd.