Load image to SQL
INSERT INTO [Images]
([ImageId]
,[FileName]
,[FileSize]
,[ImageExt]
,[CreatedDateTime]
,[ModifiedDateTime]
,[CreatedBy]
,[ModifiedBy]
,[CompanyId]
,[ImageData])
select
'Test3'
,'Test3'
,'Test3'
,'jpg'
,'1/1/2019'
,'1/1/2019'
,'Test'
,'Test'
,'Test'
,bulkColumn FROM OPENROWSET(BULK N'e:\temp\monica\flowers.jpg', SINGLE_BLOB) image
No comments:
Post a Comment