How to Handle 'Incorrect syntax near 'go'' Errors When Executing Dynamic SQL Queries?

Executing Dynamic Queries with GO in SQL

Executing dynamic queries with GO statements in SQL can lead to errors, as GO is not a recognized SQL command. To resolve this issue, it is important to remove all instances of GO from the dynamic SQL string before executing it.

Example:

Consider the following code that attempts to execute a dynamic query:

DECLARE @script VARCHAR(MAX);
SET @script = 
    '
    create table ali(id decimal(10,0));
    drop table ali;
    go
    create table ali(id decimal(10,0));
    drop table ali;
    '

EXEC (@script);

When executed, this query will result in the following error:

Msg 102, Level 15, State 1, Line 4 Incorrect syntax near 'go'.

To resolve this error, remove all instances of GO from the dynamic SQL string:

DECLARE @script   VARCHAR(MAX),
        @script1  VARCHAR(MAX);
SET @script = 
    '
    create table ali(id decimal(10,0));
    drop table ali;
    ';
SET @script1 = 
    '
    create table ali(id decimal(10,0));
    drop table ali;
    ';
EXEC (@script);
EXEC (@script1);

This modified code will successfully execute both queries without encountering the "Incorrect syntax near 'go'" error.

The above is the detailed content of How to Handle 'Incorrect syntax near 'go'' Errors When Executing Dynamic SQL Queries?. For more information, please follow other related articles on the PHP Chinese website!