unable to execute a store procedure

• sanjay.dakolia

  SSC Enthusiast

  Points: 189

  More actions

  November 7, 2012 at 1:12 am

  #264483

  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

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  November 7, 2012 at 1:23 am

  #1556659

  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
  https://www.sqlserverblogforum.com/