Home Forums SQL Server 2008 SQL Server 2008 - General how to insert images in to image table RE: how to insert images in to image table

  • February 19, 2011 at 4:49 am

    #1289169

    Try this

    insert into image (image2,id)

    select Bulkcolumn from openrowset (bulk 'path of image file', single_blob) as picture,1