if OBJECT_ID ( 'pro1', 'P' ) IS NOT NULL
ALTER procedure pro1 as select* from table1
消息 156,级别 15,状态 1,第 4 行
关键字 'procedure' 附近有语法错误。大家帮忙看一下上面句子错在哪了?如果去掉IF那一句,就可以了。
ALTER procedure pro1 as select* from table1
消息 156,级别 15,状态 1,第 4 行
关键字 'procedure' 附近有语法错误。大家帮忙看一下上面句子错在哪了?如果去掉IF那一句,就可以了。
ALTER procedure pro1
go
as
begin
select* from table1
end
drop procedure pro1
go
create procedure pro1 as select* from table1
go
drop procedure pro1
go
create procedure pro1
as
select* from table1
go
太快了,不好意思
drop procedure pro1
go
create procedure pro1
as
select* from table1
go