Hello, how are you doing? I’m having a problem running a .sql in a SQL Server database, the error that gives me the execution in liquibase is “error executing .sql sql server (Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: ‘CREATE/ALTER PROCEDURE’ must be the first statement in a query batch.)”, I paste part of the content of the script so they can help me, thanks
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[ENGAGE_AZUL].[SP_BATCH_CTRL_CORRELATIVIDAD]‘) AND type in (N’P’, N’PC’))
DROP PROCEDURE [ENGAGE_AZUL].[SP_BATCH_CTRL_CORRELATIVIDAD];
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[ENGAGE_AZUL].[SP_BATCH_CTRL_CORRELATIVIDAD]‘) AND type in (N’P’, N’PC’))
BEGIN
EXEC dbo.sp_executesql ‘arroba’statement = N’CREATE PROCEDURE [ENGAGE_AZUL].[SP_BATCH_CTRL_CORRELATIVIDAD] AS’
END
ALTER PROCEDURE [ENGAGE_AZUL].[SP_BATCH_CTRL_CORRELATIVIDAD] ('arroba’FECHACORRIDA DATETIME,
'arroba’NROJOB NUMERIC(13,0))
AS
BEGIN