I have Some image Store my system folder his image get and convert varbinary and store database table filestream field update
my storeprocedure look like This
ALTER PROCEDURE [dbo].[RFS21_GetPathTDCImgwax] As Begin Declare @Loop int, @Cnt int,@Tdcno nvarchar(25) Declare @FPath nvarchar(max) Declare @Command nvarchar(1000) Select @FPath=WaxTDC from GlobalPath set @Loop=0 select @cnt=Count(*) from TDCWax while(@Loop < @cnt) BEGIN set @Loop=@Loop+1 Select @Tdcno=TDCNO From (Select TDCNo,ROW_NUMBER() over (Order By TDCNo)AS RowNum from TDCWax)As SubOA1 where Rownum=@Loop DECLARE @File_Exists INT Declare @fpathlong as nvarchar(Max) Set @fpathlong=@FPath + '\' + @Tdcno + '.Jpeg' EXEC master.dbo.xp_fileexist @fpathlong ,@File_Exists OUTPUT If @File_Exists=1 Begin DECLARE @file_stream VARBINARY(MAX) DECLARE @Query nvarchar(mAX) set @Query = 'SELECT @file_stream1 = CAST(bulkcolumn AS varbinary(MAX)) from OPENROWSET(BULK ''' + @fpathlong + ''', SINGLE_BLOB) ROW_SET' EXEC sp_executesql @Query, '@file_stream1 VARBINARY(MAX) OUTPUT',@file_stream1 =@file_stream OUTPUT select @file_stream Update TDCWax Set TDCImg=@file_stream Where TDCNo=@Tdcno End End end
.
But error are occured
Msg 22027, Level 15, State 1, Line 0 Usage: EXECUTE xp_fileexist <filename> [, <file_exists INT> OUTPUT]