SQL format

cguanes

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

Manfred.Castro

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.

cguanes

Manfred.Castro wrote:

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