简单的存储过程传参

create proc afafs
@arear varchar(16),
@proname varchar(16)
as
select * from dbo.arear,dbo.pro where dbo.arear.arear=@arear and dbo.pro.proname=@proname
go

exec afafs '中国','aaa'