InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 23:38:01 GMT20http://www.sqlservercentral.com/Forums/Topic1381814-146-1.aspxselect @MimeType,BulkColumn from Openrowset(Bulk @[b]image [/b], 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.aspxWed, 07 Nov 2012 01:23:10 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic1381814-146-1.aspxUSE [TEMP]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER 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)ASBEGIN -- 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 )ENDi am getting the below given error : Msg 102, Level 15, State 1, Procedure csp_Images_History_Insert, Line 20Incorrect syntax near '@image'.please helpthanks in advance sanjayWed, 07 Nov 2012 01:12:17 GMTsanjay.dakolia