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!
Hi @Osboy1,
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!