SQL CE query problem: Update blob from file
I couldn't query开发者_开发问答 below, there is an error:
The Derived Table SQL construct or statement is not supported.
UPDATE [personList]
SET [personPhoto] = (
SELECT BulkColumn FROM
OPENROWSET(BULK 'C:\temp\99309.jpg', SINGLE_BLOB) rs
)
WHERE [personID] = '99309'
What am I missing? Is the syntax supported in SQL CE?
MS-SQL CE 3.5
OPENROWSET is not supported by SQL Server Compact.
精彩评论