我可以使用BCP.exe将图片数据导入SQL Server表吗?
我相信你可以,但我宁愿使用类似的东西
CREATE TABLE PictureStore (
[id] [int] IDENTITY(1,1) NOT NULL,
[filename] [varchar](255) NULL,
[created] [datetime] NULL,
[picturedata] [varbinary](max) NULL,
)
insert PictureStore (filename, created, picturedata) select '$(_FILENAME)', GETDATE(), BulkColumn from Openrowset ( Bulk '$(_FILENAME)', Single_Blob) as picturedata
如果你想要,可以使用BCP.exe导出图片数据
bcp "select top 1 picturedata from dbo.PictureStore order by created desc" queryout picturedata.zip -S fssrv -T -f bcp.fmt
是的,应该能够-下面是一个带有示例代码的网站:http://www.sqlusa.com/bestpractices/imageimportexport/
链接失效的示例:
UPDATE dbo.PhotoLibrary
SET Photo = (SELECT *
FROM OPENROWSET(BULK 'C:MyImage.JPG', SINGLE_BLOB) AS x)
WHERE ImageName = 'MyImage'