28-updateimage.sql

SQL Server 2005基础教程一书的源代码.

UPDATE TransactionDetails.Transactions
SET Notes = (
SELECT PhotoToLoad.*
FROM OPENROWSET
(BULK 'c:\Temp\photo2.jpg', SINGLE_BLOB) PhotoToLoad)
WHERE transactionId = 9