存储过程返回值问题，马上结贴！不胜感激

Question

CREATE PROCEDURE HYKH 
      @HY_NAME VARCHAR(50),@hy_riqi varchar(50),@hy_blr varchar(50),@hy_photo image
,@my_sql varchar(50) out
AS
  set @my_sql=(select right('0000000000'+cast(isnull(max(code),0)+1 as varchar),8) from hyzl) 
INSERT hyzl (code,name,riqi,blr,photo) values(@my_sql,@hy_name,@hy_riqi,@hy_blr,@hy_photo)
GO--调用
declare @my_sql varchar(50)
exec HYKH 'aa','bb',0x11,@my_sql out
select 结果=@my_sql

Answer 1

http://expert.csdn.net/Expert/topic/2965/2965780.xml?temp=.7322199