SQL format

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

SQL format

Postby cguanes » Fri Oct 25, 2013 5:14 pm

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
cguanes
 
Posts: 8
Joined: Wed Feb 08, 2012 12:28 am

Postby Manfred.Castro » Mon Oct 28, 2013 7:09 pm

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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Re:

Postby cguanes » Wed Oct 30, 2013 2:18 pm

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
Carlos Guanes
cguanes
 
Posts: 8
Joined: Wed Feb 08, 2012 12:28 am


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests