[求助]这个代表什么意思？
type后跟的值是表示什么意思这里用的是p，还有其它的值，不知道表示什么意思。那位大哥大姐知道，告诉我下?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
