Home Forums SQL Server 2005 T-SQL (SS2K5) how to insert image into a column RE: how to insert image into a column

  • July 3, 2007 at 4:48 pm

    #717021 

    CREATE TABLE myTable(Document varbinary(max))
GO

    INSERT INTO myTable(Document)    
SELECT * FROM 
OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB) 
AS Document 

    GO
    Everything you can imagine is real.