Hello, I'm trying to import images from the file system into a column of data type 'image'. An expert pointed me to the OPENROWSET(BULK... statement, but the code below gives an error: Incorrect syntax near the keyword 'BUKL'. Any ideas why? The server is Microsoft SQL Server Workgroup Edition. Any help is appreciated.
UPDATE db1.dbo.ImageValues SET Value =
(SELECT * FROM OPENROWSET( BULK 'c:\...\Image 32.JPG', SINGLE_BLOB))