存储过程这样写可以吗

[飞扬残月]

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

[飞扬残月]

那该怎么样写，可以返回参数

[PCI_E]

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

[PCI_E]

SELEC into =h_pic
FROM h_picture
WHERE h_bianhao=@ls_bianhao and h_typeid=@ls_flag

[PCI_E]

上面写错了
SELECT h_pic=@ls_pic
FROM h_picture
WHERE h_bianhao=@ls_bianhao and h_typeid=@ls_flag

[ayooxi]

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 不知道好不好用。。。。有疑问

[p405061658]

你还不如 建立个视图 让后再写存储过程

[dengshangkun]

SELECTBLOB 是什么?

[Limpire]

不可以

[kelph]

sqlserver不可以