使用SQL语句直接保存图片
use Test
go
If object_id('Picture') Is Not Null
Drop Table Picture
Go
Create Table Picture
(
FileName nvarchar(255),
ExternalFile varbinary(max)
)
Go
Insert into Picture(FileName , ExternalFile)
Select 'PitureName', BulkColumn FROM OPENROWSET(
Bulk N'G:\test.jpg', SINGLE_BLOB) As a
Go
go
If object_id('Picture') Is Not Null
Drop Table Picture
Go
Create Table Picture
(
FileName nvarchar(255),
ExternalFile varbinary(max)
)
Go
Insert into Picture(FileName , ExternalFile)
Select 'PitureName', BulkColumn FROM OPENROWSET(
Bulk N'G:\test.jpg', SINGLE_BLOB) As a
Go
