Single line GO(Batch) statement giving error in SQL Server?

Question

I have one question. I was creating below procedure temporary.

When I Execute it in below format it works fine:

CREATE PROCEDURE Get_TableList_By_Name
@Proc_Name VARCHAR(255)
AS
BEGIN
    SELECT * FROM sys.tables WHERE name LIKE '%' + @Proc_Name + '%'
END 
GO
EXEC Get_TableList_By_Name 'norway'
GO
DROP PROCEDURE Get_TableList_By_Name 
GO

But when I execute same SQL in below format it giving error saying: "Incorrect syntax near 'GO'."

CREATE PROCEDURE Get_TableList_By_Name @Proc_Name VARCHAR(255) AS BEGIN SELECT * FROM sys.tables WHERE name LIKE '%' + @Proc_Name + '%' END GO EXEC Get_TableList_By_Name 'norway' GO DROP PROCEDURE Get_TableList_By_Name GO

CREATE PROCEDURE Get_TableList_By_Name @Proc_Name VARCHAR(255) AS BEGIN SELECT * FROM sys.tables WHERE name LIKE '%' + @Proc_Name + '%' END GO 1 EXEC Get_TableList_By_Name 'norway' GO 1 DROP PROCEDURE Get_TableList_By_Name GO 1

How to write same SQL with GO statement in single line? Is it possible? If not then Why?

Thanks, Vishal

Adriaan Stander · Accepted Answer · 2014-06-10 04:59:12Z

13

From GO (Transact-SQL)

A Transact-SQL statement cannot occupy the same line as a GO command. However, the line can contain comments.

So Go needs to be on its own line, except for comments.

answered Jun 10, 2014 at 4:59

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

vishaldk Over a year ago

Thanks Astander. So there is no way to write it on single line?

John Over a year ago

There cannot be a comment after GO in the same line either ...

cdummy · Accepted Answer · 2014-06-10 05:00:54Z

4

'GO' is not a SQL command. It is a batch terminator recognized by tools like Query Analyzer, SSMS, SQLCMD, etc. These tools generally require the GO to be on a separate line and send the preceding SQL statements as a batch to SQL Server when the GO is encountered

GO Statement must be written in new line as it is not T-SQL command. T-SQL statement can not occupy the same line as GO. GO statement can contain comments.

answered Jun 10, 2014 at 5:00

cdummy

4551 gold badge4 silver badges14 bronze badges

Comments

R.Alonso · Accepted Answer · 2021-12-29 09:38:09Z

0

You can execute this:

EXEC   SP_COMMAND 1,2;
EXEC   SP_COMMAND 2,2;
EXEC   SP_COMMAND 3,2;

Set EXEC Bebore sp and ';' for end statement then select all code (SSMS) and press f5 o exec all you code by other thecnic.

answered Dec 29, 2021 at 9:38

R.Alonso

1,0751 gold badge9 silver badges11 bronze badges

Collectives™ on Stack Overflow

Single line GO(Batch) statement giving error in SQL Server?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related