Parameter Formatting in SQL Complete
Posted: Tue 11 Oct 2011 09:35
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.
The closest I can get to with the formatting options at the moment is;
Is the formatting I would like possible with the current version of SQL Complete or would this be an enhancement request?
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
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