I have a problem with formatting for SQL Server Stored Proc.... When I format this SQL :


CREATE PROC dbo.QS_CC_PAYMOVER_AUTH_DETAILS_DELETE
@RCPT_NUMBER CHAR (12),
@SEQUENCE_NUMBER SMALLINT,
@REQUEST_TIME VARCHAR (20)
AS
SET NOCOUNT ON
SET XACT_ABORT ON
BEGIN TRAN
DELETE
FROM
[dbo].[CC_PAYMOVER_AUTH_DETAILS]
WHERE
[RCPT_NUMBER] = @RCPT_NUMBER
AND
[SEQUENCE_NUMBER] = @SEQUENCE_NUMBER
AND
[REQUEST_TIME] = @REQUEST_TIME
COMMIT

and the output is all messed up....

CREATE PROC dbo.QS_CC_PAYMOVER_AUTH_DETAILS_DELETE @RCPT_NUMBER
CHAR (12), @SEQUENCE_NUMBER SMALLINT, @REQUEST_TIME VARCHAR (20)
AS
SET NOCOUNT ON
SET XACT_ABORT ON
BEGIN TRAN
DELETE
FROM
[dbo].[CC_PAYMOVER_AUTH_DETAILS]
WHERE
[RCPT_NUMBER] = @RCPT_NUMBER
AND
[SEQUENCE_NUMBER] = @SEQUENCE_NUMBER
AND
[REQUEST_TIME] = @REQUEST_TIME
COMMIT



I need to know what settings I need to get the input parms for the Stored proc to
format properly...not in a continuous line.... I have tried every setting .. line breaks after
commas, align identifiers, etc. But this just seems broken to me.



Edited 1 time(s). Last edit at 06/09/2011 03:49PM by guidomarcel.

Hi,
you are working with SQL Server, correct?
I need to add "CREATE PROC" to the parser. In the meantime you should use "CREATE PROCEDURE"

Sorry for any inconveniences
Regards
Guido

Hi,
the Issue will be fixed with new Release
Thanks for your feedback