sqlserver插入图片数据 

-- 插入
insert into [CHOLPOR].[dbo].[t_image](id, name) select '1', BulkColumn from openrowset(bulk N'e:\1.jpg', single_blob) as blob;

-- 更新
update dbo.EArcImage set EArcImage = (select BulkColumn from openrowset(bulk N'e:\1.jpg', single_blob) as blob )where earcimage.EArcImageID='D1241F59-3AB8-4A03-9895-B20450D03077'

 

posted on 2018-04-23 09:16  菜鸟Z  阅读(1132)  评论(0)  编辑  收藏  举报

导航