How can we help you today? How can we help you today?

v4 formats this differently than v3

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.
Oliwa
0

Comments

3 comments

Sort by
  • Anu D
    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?
    Anu D
    0
  • Oliwa
    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.
    Oliwa
    0
  • Anu D
    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.
    Anu D
    0

Add comment

Please sign in to leave a comment.