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