正确的写法:If exists(select name from sysobjects where name='author_information' And type='p') drop Procedure author_information gocreate procedure author_information as select au_lname,au_fname,title,pub_name from authors a join titleauthor ta on a.au_id=ta.au_id join titles t on t.title_id=ta.title_id join publishers p on t.pub_id=p.pub_id go运行N次都没问题.
将存储过程 名author_information 简化成'au_info',是随意简化,还是有规律?好像不太对吧?
你运行两次试试.这是我测试的结果:服务器: 消息 2714,级别 16,状态 5,过程 author_information,行 4
数据库中已存在名为 'author_information' 的对象。
where name='author_information' And type='p')
drop Procedure author_information
gocreate procedure author_information
as
select au_lname,au_fname,title,pub_name
from authors a
join titleauthor ta
on a.au_id=ta.au_id
join titles t
on t.title_id=ta.title_id
join publishers p
on t.pub_id=p.pub_id
go运行N次都没问题.