存储过程这样写可以吗
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 h_bianhao=@ls_bianhao and h_typeid=@ls_flag
select h_pic_bak into @ls_pic_bak
FROM h_picture
WHERE h_bianhao=@ls_bianhao and h_typeid=@ls_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 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
[解决办法]
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 不知道好不好用。。。。有疑问
