What are the challenges you face when working across database platforms? Take the survey
Options

How can I edit my Custom Active Style to NOT put semicolons in certain places?

Hi folks, brand new user here.

I want this:
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[someSproc]
AS 

BEGIN
	declare @M nvarchar(128);
	declare @P nvarchar(128);
	declare @R nvarchar(128);
        ...

But I get this:
SET ANSI_NULLS ON;
GO

SET QUOTED_IDENTIFIER ON;
GO

CREATE PROCEDURE [dbo].[someSproc]
AS 

BEGIN
	declare @M nvarchar(128);
	declare @P nvarchar(128);
	declare @R nvarchar(128);
        ...

I have the indentation, comma placement, capitalization, etc. working how I want. I just can't figure out how to omit the semicolons when preceding a GO.

I also know that I don't actually need the GO statements in there per se, but I am very accustomed to them and put them in by reflex. Plus, they are part of the standard syntax style that a lot of our legacy code uses and I like to be consistent.

Any help would be appreciated, thanks!
Tagged:

Answers

Sign In or Register to comment.