@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"。
请教问题答案,谢谢!