SQL Server的存储过程介绍

create procedure pro_GetName(@name varchar(100),@realName varchar(100) Output)
as
select @realName=realname from t_user left join t_userinfo on t_user.id=T_userInfo.id where name=@name

//调用输出参数，一定要在外面定义一个
declare @realName varchar(100)
exec pro_GetName 'jack',@realName Output
print @realName



create procedure pro_Calculate
as
declare @total int
select @total=count(id) from t_User where name='Kevin'
print @total

pro_Calculate