Comments
2 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 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
Add comment
Please sign in to leave a comment.
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