'CREATE/ALTER PROCEDURE' 必须是查询批次中的第一个语句。

if object_id('str_EatDefaultR_object')is not null
    drop proc str_EatDefaultR_object
--go -- 失败

go --成功
CREATE PROCEDURE str_EatDefaultR_object
AS
BEGIN
    select * from dbo.Eat_Object
END
GO

转载于:https://www.cnblogs.com/ok519/archive/2009/06/30/1514276.html