問題描述

我有一個問題.我正在創(chuàng)建以下程序臨時.

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

當我以下面的格式執(zhí)行它時，它工作正常:

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

但是當我以下面的格式執(zhí)行相同的 SQL 時，它給出錯誤提示:'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

如何在單行中用 GO 語句編寫相同的 SQL?是否可以?如果不是，那為什么?

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

謝謝，維沙爾

推薦答案

來自 GO (Transact-SQL)

Transact-SQL 語句不能與 GO 命令占據(jù)同一行.但是，該行可以包含注釋.

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

所以除了注釋之外，Go 需要獨占一行.

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

這篇關于單行 GO(Batch) 語句在 SQL Server 中出錯?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！