TIPS N' SAMPLES
Useful tips and samples for software developers
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
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment