请教执行存储过程问题

ypine 2009-11-07 03:27:14

CREATE PROCEDURE InsertPicture
@image_id int,
@image_type nvarchar(40),
@image_code nvarchar(40),
@image_status int,
@image_path nvarchar(80)
AS
DECLARE @S nvarchar(800)

SET @S =
N'INSERT INTO Tbl_Image
(Image_id,
Image_Type,
Image_Code,
Image_Status,
image_Image)
SELECT
@image_id as image_id,
@image_type as image_type,
@image_code as image_code,
@image_status as image_status,
* FROM Openrowset (BULK' + @image_path + ',single_blob) as image_image'
EXEC(@S)
GO
-----------------------------------------------------------------------
USE [ProductQuery]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[InsertPicture]
@image_id = 100,
@image_type = N'3',
@image_code = N'90100',
@image_status = 1,
@image_path = N'c;\p1.gif'

SELECT 'Return Value' = @return_value

GO

出现如下错误：必须声明标量变量 "@image_id"。
请教问题答案，谢谢！

...全文

141 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

让你望见影子的墙 2009-11-07

打赏
举报

set @return_value =exec( [dbo].[InsertPicture] 

@image_id = 100, 

@image_type = N'3', 

@image_code = N'90100', 

@image_status = 1, 

@image_path = N'c;\p1.gif' )



SELECT 'Return Value' = @return_value

叶子 2009-11-07

打赏
举报

[Quote=引用 2 楼 rucypli 的回复:]
四列插五列？
[/Quote]
不是的，最后还有一个星号，应该是一列这样就5列插5列了

ypine 2009-11-07

打赏
举报

INSERT INTO Tbl_Image
(Image_id,
Image_Type,
Image_Code,
Image_Status,
image_Image)
SELECT
100 as image_id,
'3' as image_type,
'90100' as image_code,
1 as image_status,
* FROM Openrowset(BULK 'c:\p1.gif',single_blob) as image_image

这段代码没问题的，可以插入一条数据。

--小F-- 2009-11-07

打赏
举报

insert into ...select ...前后一定要一一对应

--小F-- 2009-11-07

打赏
举报

SET @S = 

N'INSERT INTO Tbl_Image 

(Image_id, 

Image_Type, 

Image_Code, 

Image_Status, 

image_Image) 

SELECT 

@image_id as image_id, 

@image_type as image_type, 

@image_code as image_code, 

@image_status as image_status,

@image_Image as image_Image

* FROM Openrowset (BULK' + @image_path + ',single_blob) as image_image' 

EXEC(@S)