v4 formats this differently than v3

OliwaOliwa Posts: 42 Bronze 2
edited August 10, 2010 5:25AM in SQL Prompt Previous Versions
I recently upgraded to v4.0.3 from v3.9 and when SQL Prompt auto generates my insert statement it now does this...
INSERT      dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VALUES  ( 0, -- PortfolioID - int
          0  -- ServicingTypeID - int
          )

Where it used to do this...
INSERT      dbo.PortfolioServicingType ( PortfolioID, ServicingTypeID )
VALUES     ( 0, /* PortfolioID - int */, 0 /* ServicingTypeID - int */)

I am using standard edition.

Comments

  • Many thanks for your post.

    Yes it has been changed since version 3.

    Any specific reason you would like the values option on single line?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • OliwaOliwa Posts: 42 Bronze 2
    I actually don't, I want the format of the insert to be like this...
    INSERT      dbo.PortfolioServicingType
                     (
                         PortfolioID
                         , ServicingTypeID
                     )
    VALUES      (
                         0 -- PortfolioID
                         , 0  -- ServicingTypeID
                     )
    

    But since I don't think the Standard version will do that putting it all on one line makes it easier for me to format how I want it.
  • Oh!

    It is configurable in SQL Prompt professional edition.

    I am sorry about that!

    I have added this as a feature request to format it as per your request.

    i.e. values on one line. Tracking id for the feature request is SP-3334.

    I will update you as soon as it is incorporated.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.