查找两表不匹配的数据! 本帖最后由 AthlonXP2000 于 2012-05-16 12:24:45 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --> 测试数据:[t1]if object_id('[t1]') is not null drop table [t1]create table [t1]([cn] varchar(3),[phone] int,[bm] int,[address] varchar(6))insert [t1]select 'abc',111111,22222,'123abc'--> 测试数据:[t2]if object_id('[t2]') is not null drop table [t2]create table [t2]([cn] varchar(3),[phone] int,[bm] int,[address] varchar(6),[ckphone] sql_variant,[ckbm] sql_variant,[ckaddress] sql_variant)insert [t2]select 'abc',111111,22223,'abc123',null,null,nullupdate t2set [ckphone]=t.phone,[ckbm]=t.bm,[ckaddress]=t.[address]from(select * from t1 a where not exists(select 1 from t2 b where a.cn=b.cn and a.phone<>b.phone))t where t.cn=t2.cnselect * from t2/*cn phone bm address ckphone ckbm ckaddressabc 111111 22223 abc123 111111 22222 123abc*/ 难题来了……关于验证15位18位身份证的问题。比较苛刻,希望高手来[最先给予完美答案的送QQ黄钻一个月] sql while循环 数据更新 查询语句中的inner join对性能影响多大? 简单问题,速结! 关于多表分组查询(高手请进) insert相同的列每隔30列 asp程序只能查询数据库中系统自带的表,我建的表,查询出错 sql server的问题,没分了,对不起,帮帮我,急,分数改天奉上 能否给我这个新手推荐几本学习visual foxpro的好书?????? 这样的查询结果怎么实现? 急求... 再来一个子查询。麻烦大家了。
--> 测试数据:[t1]
if object_id('[t1]') is not null
drop table [t1]
create table [t1](
[cn] varchar(3),
[phone] int,
[bm] int,
[address] varchar(6)
)
insert [t1]
select 'abc',111111,22222,'123abc'
--> 测试数据:[t2]
if object_id('[t2]') is not null drop table [t2]
create table [t2](
[cn] varchar(3),
[phone] int,
[bm] int,
[address] varchar(6),
[ckphone] sql_variant,
[ckbm] sql_variant,
[ckaddress] sql_variant
)
insert [t2]
select 'abc',111111,22223,'abc123',null,null,nullupdate t2
set [ckphone]=t.phone,[ckbm]=t.bm,[ckaddress]=t.[address]
from(
select * from t1 a where not exists(
select 1 from t2 b where a.cn=b.cn and a.phone<>b.phone
))t where t.cn=t2.cnselect * from t2
/*
cn phone bm address ckphone ckbm ckaddress
abc 111111 22223 abc123 111111 22222 123abc
*/