Create PROC insert2img
as
Begin
	Declare @img1 as varbinary(max) 
	Declare @dircmd as varchar(max)
	DECLARE @filename varchar(100)
	DECLARE @filepath varchar(100)
	DECLARE @maxRowID int
	DECLARE @count int
	DECLARE @tempXMLFileName table (RowId int identity(1,1), name varchar(100))
	Declare @sql as varchar(max)

        Set @count =1 
        Set @dircmd = 'MASTER..XP_CMDSHELL "dir/b '+ 'F:\Images\*.*"'
 
	INSERT 
	     @tempXMLFileName exec (@dircmd)

        SET @maxRowID = (SELECT max(RowId) FROM @tempXMLFileName)

WHILE @count <= @maxRowID
 BEGIN
          SET @filename = (SELECT name FROM  @tempXMLFileName   
          WHERE [RowId] = @count)
          Set @filepath = 'F:\Images\'+@filename'

          Set @sql = '
	    Insert into img (sno,imgdate,imgname,img) 
	        Select @count,getdate(),''Image'', 
                     BulkColumn from Openrowset( 
                     Bulk ''' + @filepath + ''', Single_Blob) as tt            
'
        Exec (@sql)

        Set @filepath=' ' 
        Set @count = @count + 1 			         
end

end