unable to execute a store procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » unable to execute a store procedure

unable to execute a store procedure

Rate Topic

Display Mode

Topic Options

Author

Message

sanjay.dakolia

Posted Wednesday, November 07, 2012 1:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 16, 2012 11:53 PM
Points: 9, Visits: 17

USE [TEMP]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[psp_TEMP]
-- Add the parameters for the stored procedure here
@MimeType varchar(50),
@image image,
@Hid int,
@ImageName varchar(100),
@ImageDesc varchar(100)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
insert into image
(
MimeType,
image
)
select @MimeType,BulkColumn from Openrowset(Bulk @image , Single_Blob) as EmployeePicture
--values
--(
--@MimeType,
--@image
--)

declare @imageId int
set @imageId = @@identity

insert into tables
(
HistoryID,
ImageID,
ImageName,
ImageDescription
)
values
(
@Hid,
@imageId,
@ImageName,
@ImageDesc
)
END

i am getting the below given error :

Msg 102, Level 15, State 1, Procedure csp_Images_History_Insert, Line 20
Incorrect syntax near '@image'.

please help

thanks in advance
sanjay

Post #1381814

muthukkumaran Kaliyamoorthy

Posted Wednesday, November 07, 2012 1:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:22 AM
Points: 1,123, Visits: 4,423

select @MimeType,BulkColumn from Openrowset(Bulk @image , Single_Blob) as EmployeePicture

| BULK 'data_file' ,
{ FORMATFILE = 'format_file_path' [ <bulk_options> ]
| SINGLE_BLOB | SINGLE_CLOB | SINGLE_NCLOB }

Have a look: http://msdn.microsoft.com/en-us/library/ms190312.aspx

Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum

Post #1381817

« Prev Topic | Next Topic »

Permissions