create table img_list
(
imgID int not null,
imgName varchar(60),
imgValue varbinary(max) not null
)
go
--加入数据
insert into img_list(imgID,imgName,imgValue)
select 1 as imgID,'winter' as imgName,* from
openrowset(bulk'F:\shuijingan\Adobe\Adobe2.jpg',single_blob) as imgValue
--查看数据的长度
select length=datalength('imgValue'),imgvalue--为什么这儿会返回 8 ?
from img_list
order by imgID
(
imgID int not null,
imgName varchar(60),
imgValue varbinary(max) not null
)
go
--加入数据
insert into img_list(imgID,imgName,imgValue)
select 1 as imgID,'winter' as imgName,* from
openrowset(bulk'F:\shuijingan\Adobe\Adobe2.jpg',single_blob) as imgValue
--查看数据的长度
select length=datalength('imgValue'),imgvalue--为什么这儿会返回 8 ?
from img_list
order by imgID
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货