请教执行存储过程问题

[ypine]

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"。
请教问题答案，谢谢！

[SQL77]

你先PRINT @SQL出来

[rucypli]

四列插五列？

[SQL77]

[Quote=引用 2 楼 rucypli 的回复:]
四列插五列？
[/Quote]
额厉害,楼主少了

[--小F--]

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) 

[--小F--]

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

[ypine]

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

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

[叶子]

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

[让你望见影子的墙]

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