Red Gate forums :: View topic - SQL format
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

SQL format

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cguanes



Joined: 08 Feb 2012
Posts: 8

PostPosted: Fri Oct 25, 2013 5:14 pm    Post subject: SQL format Reply with quote

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
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Mon Oct 28, 2013 7:09 pm    Post subject: Reply with quote

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/94413-sql-prompt-feature-suggestions
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
Back to top
View user's profile Send private message
cguanes



Joined: 08 Feb 2012
Posts: 8

PostPosted: Wed Oct 30, 2013 2:18 pm    Post subject: Re: Reply with quote

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/94413-sql-prompt-feature-suggestions
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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group