SQL Server - Insert file in Varbinary field

INSERT INTO myTable select * from openrowset(BULK N'C:\serverFolder\file.jpg', SINGLE_BLOB) as imagedata; UPDATE myTable SET file=(select * from openrowset(BULK N'C:\serverFolder\file.jpg', SINGLE_BLOB) as imagedata);

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.