use pubs
if exists select name from sysobjects
where name=’author_infor and type=’p’
drop procedure author_infor
go
use pubs
go
create procedure author_infor
@lastname varchar 40 , @firstname varchar 20
as
select au_lname,au_fname,title, pub_name
from authors a inner join titleauthor ta
on a.au_id=ta.au_id inner join ttitles t
on t.title_id=ta.title_id inner join publishers p
on t.pub_id=p.pub_id
where au_fname=@firstname and au_lname=@lastname
go