sql server - 11.24

use test10
if exists (select name from sysobjects where name = 'author_infor')
drop proc author_infor
go
Create proc author_infor as
select *
from chengji
go

exec author_infor