Skip to content

Incorrect syntax near 'GO' #1721

@SiroccoBreeze

Description

@SiroccoBreeze

The script I executed contains GO, but an error message Incorrect syntax near 'GO' is displayed. However, I can execute the same script in SQL Server Management Studio. Is there any way to fix this?

Expected behaviour:

Actual behaviour:

Configuration:

// paste relevant config here

Database scripts

if exists(select 1 from sys.objects where type='P' and name='usp_report_cwzt_cybrlist_ssis')
drop proc usp_report_cwzt_cybrlist_ssis
GO
 
 CREATE proc usp_report_cwzt_cybrlist_ssis
 @ksrq ut_rq16,
 @jsrq ut_rq16
……

Software versions

  • NodeJS: 22.12.0
  • node-mssql:11.0.1
  • SQL Server:Microsoft SQL Server 2022 (RTM-CU16) (KB5048033) - 16.0.4165.4 (X64) Nov 6 2024 19:24:49 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Linux (Ubuntu 22.04.5 LTS)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions