小型维护计划的存储过程中出错

Question

我在尝试创建存储过程时遇到错误。我试着弄清楚，但经过一段时间后，我决定问一问。

以下是我的SP的代码：

ALTER PROCEDURE [dbo].[sp_maintenance]

AS

begin

            dbcc checkdb('BD_Farmacia')

            GO
            ALTER INDEX ALL ON Artigo
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Categoria
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Composicao
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Iva
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Linha_venda
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Lote
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Utente
            REBUILD
            GO

            GO
            ALTER INDEX ALL ON Venda
            REBUILD
            GO


end
RETURN

以下是错误消息：

Msg 102, Level 15, State 1, Procedure sp_maintenance, Line 8
Incorrect syntax near ')'.
Msg 156, Level 15, State 1, Line 4
Incorrect syntax near the keyword 'RETURN'.

有人能帮帮忙吗？谢谢恰帕

Answer 1

不能在存储过程中包含GO -它用于分隔多个批处理的SQL。