select * into TestT__ from.... 为什么要into TestT__,TestT__是一张实表吧,你的结果是想干嘛
查询两张表(TestT,TestT_)提取不同的数据写到TestT__表
我晕你的表真让人受不了,TestT__跟TestT_不一样,不仔细看,还以为。你考验人眼里
select * into TestT__ from( select * from TestT a where not exists (select * from TestT_ where CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120)) union all select * from TestT_ a where not exists (select * from TestT where CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120))) a
select * into test_t from testt t where not exists(select 1 from TestT where convert(varchar(13),dt,120)=convert(varchar(13),t.dt,120)
INSERT into TestT__ SELECT * from TestT where not exists (select 1 from TestT_ where CONVERT(char(13), TestT.DT, 120) = CONVERT(char(13), TestT_.DT, 120))
我有点不懂了testT_表还多一条数据 还有必要插入么?
难道是这样? insert ino TestT__ SELECT * from TestT where not exists (select 1 from TestT_ where CONVERT(char(13), TestT.DT, 120) = CONVERT(char(13), TestT_.DT, 120))
select * into TestT__ from( select * from TestT a where not exists (select * from TestT_ where CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120)) union all select * from TestT_ a where not exists (select * from TestT where CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120))) a这个写法可以实现你的要求
为什么要into TestT__,TestT__是一张实表吧,你的结果是想干嘛
select * from TestT a
where not exists (select * from TestT_ where
CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120))
union all
select * from TestT_ a
where not exists (select * from TestT where
CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120))) a
*
into
test_t
from
testt t
where
not exists(select 1 from TestT where convert(varchar(13),dt,120)=convert(varchar(13),t.dt,120)
insert ino
TestT__
SELECT
*
from
TestT
where
not exists (select 1 from TestT_ where CONVERT(char(13), TestT.DT, 120) = CONVERT(char(13), TestT_.DT, 120))
select * from TestT a
where not exists (select * from TestT_ where
CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120))
union all
select * from TestT_ a
where not exists (select * from TestT where
CONVERT(char(13), DT, 120) = CONVERT(char(13), a.DT, 120))) a这个写法可以实现你的要求