SQL format

cguanescguanes Posts: 18 Bronze 3
edited October 30, 2013 9:18AM in SQL Prompt
Hi, I'm using SQL Prompt 6.1.0.72.

Inside my SP I create a temporary table and I need to define the default
values, when I run the SQL Format it keep moving the "Default" to next line, I would like to keep in the same line.

I looked each option on the configuration and I couldn't find how to change this behavior...

This is what I have after formatting

,[insertDT] DATETIME NULL
[_________INDENT______] DEFAULT GETDATE()
,[ActualMU] INT NULL
[_________INDENT______]DEFAULT 0
,[PlannedMu] INT NULL
[_________INDENT______]DEFAULT 0
,[CompletedDT] DATETIME NULL
[_________INDENT______] DEFAULT GETDATE()

and I would to see...

,[insertDT] DATETIME NULL DEFAULT GETDATE()
,[ActualMU] INT NULL DEFAULT 0
,[PlannedMu] INT NULL DEFAULT 0
,[CompletedDT] DATETIME NULL DEFAULT GETDATE()


What do I need to change? Thanks
Carlos Guanes

Comments

  • Unfortunately there doesn't appear to be a format setting to have SQL Prompt format the way you want.
    This would be considered a feature request.
    If you wish you can request this feature here.
    http://redgate.uservoice.com/forums/944 ... uggestions
    These forums are actively monitored by our development team and allow our users to request features and vote on them.
    If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
    Manfred Castro
    Product Support
    Red Gate Software
  • cguanescguanes Posts: 18 Bronze 3
    Unfortunately there doesn't appear to be a format setting to have SQL Prompt format the way you want.
    This would be considered a feature request.
    If you wish you can request this feature here.
    http://redgate.uservoice.com/forums/944 ... uggestions
    These forums are actively monitored by our development team and allow our users to request features and vote on them.
    If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.

    Ok, I added as suggestion
    Carlos Guanes
Sign In or Register to comment.