1.两个结构一样的表a和b,怎么样从b中把不在a里的记录用一条查询语句列出来?
select * from b where b.id not in (select id from a)
2.出现该表中已有继承了标识属性的列 'id'
解决办法,我将标识列转化成varchar并重新命名了一列a:
@Source参数这样赋值:
select Convert(varchar(10),id) as a,* from 表名 where 条件
@List参数这样赋值:
a,title,color
@Order参数一定要用标识列:
id
3.
drop table #t
select IDENTITY(INT, 1, 1) AS Rank,Convert(varchar(10),gid) as a into #t from tgongwen
select a from #t where Rank between 9001 and 10000
select * from (select top 10000 * from tgongwen) as b where b.gid not in(select top 9000 gid from tgongwen)
评论