Hi,

Here is the code what i used to execute successfully,

Please have the Image column at the last in insert query,

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create PROC [dbo].[insert2img]

as

Begin

Declare @img1 as varbinary(max) --Declare...

Thanks

Balaji

Actually i got the following errors like

Incorrect syntax near '@filename'.

For inserting images in to database i used the following code

BulkColumn from Openrowset( Bulk 'F:\Images\picture005.jpg', Single_Blob) as tt ...