sqlserver中定义过程

今天需要写sqlserver过程 ，参考一个朋友的blog

http://203.208.39.132/search?q=cache:zV_HAsH9BFAJ:tech.ddvip.com/2008-08/121826978452413.html+sql+server+%E5%AD%98%E5%82%A8%E8%BF%87%E7%A8%8B&cd=3&hl=zh-CN&ct=clnk&gl=cn&st_usg=ALhdy296pgMo-AF_aH7hk38QfkhvAYr4wQ

http://yaoronghui2005.itpub.net/admin.php?op=editPost&postId=494044

2009-11-24 今天编辑一个过程调用

alter procedure p_process @id varchar(10), @v_name varchar(20) output

as

select @v_name=name from t_test t where id = @id;

exec p_process @id='1', @v_name output[雨林木风1]

exec p_process '1', @v_name output 正确写法1

EXEC p_process @id='1', @v_name = [雨林木风2] out //正确写法2

DECLARE @v_name varchar(200)

set @v_name = ''

EXEC p_process @id='1', @v_name = output

if @v_name <> ''

begin

select * from t_test where name = @v_name;

end

else if @v_name = ''

begin

raiserror('no row found',10,1);

end