Parameter Formatting in SQL Complete

[jbroomfield]

Hi there,

I'm relatively new to SQL Complete and am still getting to grips with what it can do so my query may be down to me not finding the right combination of formatting switches yet.

I normally write my sql code so that the Parameters for a stored proc or function are indented while the opening/closing brackets for the parameter list are themselves on newlines but not indented.

Code: Select all

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[usp_eUserAdd]
(
    @eUserName             NVARCHAR(100),
    @ePassword             NVARCHAR(32),
    @eReportsTo            NVARCHAR(100),
    @eDeliverAlertsByEMail SMALLINT,
    @eEMailAddress         NVARCHAR(100),
    @eDistinguishedName    NVARCHAR(225),
    @eDirectoryTree        NVARCHAR(225),
    @eUpdatedTime          DATETIME
)
AS
BEGIN

The closest I can get to with the formatting options at the moment is;

Code: Select all

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROC [dbo].[usp_eUserAdd](@eUserName NVARCHAR(100),
    @ePassword             NVARCHAR(32),
    @eReportsTo            NVARCHAR(100),
    @eDeliverAlertsByEMail SMALLINT,
    @eEMailAddress         NVARCHAR(100),
    @eDistinguishedName    NVARCHAR(225),
    @eDirectoryTree        NVARCHAR(225),
    @eUpdatedTime          DATETIME
    )
AS
BEGIN

Is the formatting I would like possible with the current version of SQL Complete or would this be an enhancement request?

[.jp]

Hello,
Thanks for the post.

Currently such formatting is not implemented yet. In future versions the amount of statements and settings for formatting will be extended including "ALTER PROC".

Best Regards.

[alexa]

The feature you requested is implemented now in the new version (3.5) of dbForge SQL Complete that is already available for downloading: http://www.devart.com/dbforge/sql/sqlco ... nload.html

Thank you for your help in improving dbForge SQL Complete.