Sunday, February 3, 2013

Insert binary data (ie. images) into SQL Server without front-end application

CREATE TABLE myTable(Document varbinary(max)) 

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


No comments:

Post a Comment