27-image-lob.sql

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

INSERT INTO TransactionDetails.Transactions
(CustomerId, TransactionType, DateEntered,Amount,Notes, RelatedProductId)
SELECT 2, 1, GETDATE(),1000,PhotoToLoad.*, 1
FROM OPENROWSET
(BULK 'c:\temp\photo.tif', SINGLE_BLOB) PhotoToLoad