A fairly common problem is inserting data directly into binary data columns in SQL Server without a front-end application. The example below is the simplest solution I've seen and can be run straight from SQL Server Management Studio (SSMS).
In the below example I'm updating the an image column 'Icon' with an image file saved on the hard drive.
Update myTable
set Image = (
SELECT *
FROM OPENROWSET(BULK N'C:\image.png', SINGLE_BLOB) test)
where ImageID = 1
Showing posts with label image. Show all posts
Showing posts with label image. Show all posts
Subscribe to:
Posts (Atom)