- 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
使用SQL语句直接保存图片
最新推荐文章于 2020-11-05 15:40:57 发布