存储过程这样写可以吗解决方法

存储过程这样写可以吗
CREATE   PROCEDURE   READ_PICTURE  
  @ls_flag   varchar(6),
@ls_bianhao   varchar(6),
@ls_pic   blob     output,
@ls_pic_bak   varchar(4)   output
as
SELECTBLOB   h_pic   into   @ls_pic
FROM   h_picture  
WHERE   [email protected]_bianhao   and   [email protected]_flag

select   h_pic_bak   into   @ls_pic_bak
FROM   h_picture  
WHERE   [email protected]_bianhao   and   [email protected]_flag
go

------解决方案--------------------
CREATE PROCEDURE READ_PICTURE
@ls_flag varchar(6),
@ls_bianhao varchar(6),
@ls_pic blob output,
@ls_pic_bak varchar(4) output
as
SELECTBLOB h_pic into @ls_pic
FROM h_picture
WHERE [email protected]_bianhao and [email protected]_flag

select @ls_pic_bak=h_pic_bak
FROM h_picture
WHERE [email protected]_bianhao and [email protected]_flag
go

------解决方案--------------------
CREATE PROCEDURE READ_PICTURE
@ls_flag varchar(6),
@ls_bianhao varchar(6),
@ls_pic blob output,
@ls_pic_bak varchar(4) output
as
SELECTBLOB @ls_pic = h_pic
FROM h_picture
WHERE h_bianhao = @ls_bianhao and h_typeid = @ls_flag

select @ls_pic_bak = h_pic_bak
FROM h_picture
WHERE h_bianhao = @ls_bianhao and h_typeid = @ls_flag
go

另外SELECTBLOB 不知道好不好用。。。。有疑问