ms sql´æ儲過³Ì參數·µ»ØÖµ

create table tabReProc
 (    
 name varchar(30),    
 age integer,    
 primary key(name,age)    
 ) 
 insert into tabReProc values('x7700',20) 
 insert into tabReProc values('x7711',21) 
 insert into tabReProc values('x7733',23) 
 insert into tabReProc values('x7755',25) 
if exists(select *from dbo.[sysobjects] where [name]='proc1')
   drop proc proc1
go
 create procedure proc1(@parm1 integer,@parm2 varchar(30) output) 
 as    
 select @parm2='zhongguo'    
 select * from tabReProc where age=@parm1    
 return 100    
go
declare @tmpa int 
declare @param1 int ,@param2 varchar(30) 
select @param1=20 
execute @tmpa=proc1 @param1,@param2 output 
select  @tmpa,@param2