sql查询 sql 判断一个表里的字段在另一个表里有没有? 把没有的列出来这个怎么写SQL啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from table1 where field not in (select field from table2) SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJCT_ID('TB1')AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJCT_ID('TB2')) select name from syscolumns where id=object_id('TableName1')where namenot in (select name from syscolumns where id=object_id('TableName2')) SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB1')AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB2')) select [name] from syscolumns where id=object_id('TableName1')where [name] not in (select [name] from syscolumns where id=object_id('TableName2')) select * from tab not in(select field from tab1) SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJCT_ID('TB1')AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJCT_ID('TB2')) SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('sys_corp')AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('sys_corp_table')) 接着上面的问表A 有一个字段 建档时间表B现在想要实现 表A的建档时间+30天 表B中还没有出现的A表记录高手帮忙 select name from syscolumns where id=object_id('TableName1')where namenot in (select name from syscolumns where id=object_id('TableName2')) 接着上面的问 表A 有一个字段 建档时间 表B 现在想要实现 表A的建档时间+30天 表B中还没有出现的A表记录 高手帮忙 SELECT * FROM A T WHERE NOT EXISTS(SELECT 1 FROM B WHERE CONVERT(VARCHAR(10),DATEADD(DD,30,T.DATE),120)=CONVERT(VARCHAR(10),DATE,120))是这意思? select name from syscolumns where id=object_id('TableName1')where namenot in (select name from syscolumns where id=object_id('TableName2')) windows server 2008 R2 安装 SQL2008后启动提未系统找不到提定文件 sql语句执行效率问题 求一些T-sql编程容易出错的列子或应该注意的地方 请问我这条sql应该怎样改? 排序 sql 关于SQL 2000的安装问题:“以前的某个程序安装已在安装计算机上创建挂起的文件操作,运行安装程序之前必须重新启动计算机” sql语句求助,有分 请问以SQL SERVER做数据引挚,以什么软件做前端界面设计好点? SQL2005无法登录 怎么设计这样的字段类型? SQLserver管理与开发技术大全的关盘内容 谁有? 本人初学SQL2005有问题请教
AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJCT_ID('TB2'))
name
from
syscolumns where id=object_id('TableName1')
where
name
not in
(select name from syscolumns where id=object_id('TableName2'))
AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('TB2'))
select [name] from syscolumns where id=object_id('TableName1')
where [name] not in
(select [name] from syscolumns where id=object_id('TableName2'))
AND NAME NOT IN(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJCT_ID('TB2'))
AND NAME NOT IN
(SELECT NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID('sys_corp_table'))
表A 有一个字段 建档时间
表B
现在想要实现 表A的建档时间+30天 表B中还没有出现的A表记录高手帮忙
name
from
syscolumns where id=object_id('TableName1')
where
name
not in
(select name from syscolumns where id=object_id('TableName2'))
表A 有一个字段 建档时间
表B
现在想要实现 表A的建档时间+30天 表B中还没有出现的A表记录 高手帮忙
SELECT * FROM A T WHERE
NOT EXISTS(
SELECT 1 FROM B WHERE CONVERT(VARCHAR(10),DATEADD(DD,30,T.DATE),120)=
CONVERT(VARCHAR(10),DATE,120))
是这意思?
name
from
syscolumns where id=object_id('TableName1')
where
name
not in
(select name from syscolumns where id=object_id('TableName2'))