The semicolon in a SQL script

Liquibase Development
1

I,
In an SP, I have to issue the WITH statement. This instruction requires that the previous instruction explicitly ends with a semicolon.

The semicolon causes an error with liquibase.

What parameter should I add to my script so that liquibase behaves the same way as SQL Server?

HEADER on the file :

– liquibase formatted sql

/* ****************************************************************************************************************** */

– changeset mba:JobName stripComments:false splitStatements:true dbms:mssql
– comment: JobComment.

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE OR ALTER TRIGGER [dbo].[tr_ai_name]
ON [dbo].[table]
FOR INSERT
AS
BEGIN
…

SELECT @var = ‘rr’;
WITH (…

END

2

semicolon is the default statement delimiter in Liquibase. You’ll need to set a different end delimiter if your sql contains a semicolon. See here for more details: