为什么我用union合并关键字向数据库中插入数据 的时候,text类型的数据不能插入呢?

来源：百度知道 编辑：UC知道 时间：2024/05/09 12:53:54
use xinhua
go

--向表Gaoxin中插入数据
insert into Gaoxin (U_id,Uname,Upassword,Uaddress,Usex)
select 'robinn','kjljk','robinn','dsfasasdf','ssss' union
select 'robinn','saf','robinn','dsfasasdf','ssss' union
select 'robinn','dsfsdfs','robinn','dsfasasdf','ssss' union
select 'robinn','sdfasdf','robinn','dsfasasdf','ssss' union
select 'robinn','gfgf','robinn','dsfasasdf','ssss'

go

union 在默认情况下 消除重复项

消除重复项（distinct） 不能过滤 text、ntext 或 image 类型

insert into Gaoxin (U_id,Uname,Upassword,Uaddress,Usex)
select 'robinn','kjljk','robinn','dsfasasdf','ssss' union all
select 'robinn','saf','robinn','dsfasasdf','ssss' union all
select 'robinn','dsfsdfs','robinn','dsfasasdf','ssss' union all
select 'robinn','sdfasdf','robinn','dsfasasdf','ssss' union all
select 'robinn','gfgf','robinn','dsfasasdf','ssss'

加一个all修饰符就可以了