这里是我的SQL语句select b.vip_no,b.vip_name,b.sex,b.hydj_name,
a.dtime,a.consume,a.score,a.lr_name,b.yhfs_name,b.smoney
,b.autoupdate,b.address,b.addinfo,b.ftel,b.idcard,b.born,
b.company,b.email,
rowid=identity(int,1,1)
into #f
from vip_scores a,vip_user b
where a.dtime between '2008-04-27 13:51:15.453' and '2010.01.01' and b.vip_no=a.xno and
isnull(YHFS_NO,'') LIKE ''
order by a.dtimeselect vip_no,vip_name,sex,hydj_name,dtime,consume,score,yhfs_name,smoney,autoupdate,
address,addinfo,ftel,idcard,born,company,email
from #f
where rowid between 1 and 25我如果选择条件查询的时候 YHFS_NO选择的为空 他能把所有的YHFS_NO为空或者不为空的记录都查出来
a.dtime,a.consume,a.score,a.lr_name,b.yhfs_name,b.smoney
,b.autoupdate,b.address,b.addinfo,b.ftel,b.idcard,b.born,
b.company,b.email,
rowid=identity(int,1,1)
into #f
from vip_scores a,vip_user b
where a.dtime between '2008-04-27 13:51:15.453' and '2010.01.01' and b.vip_no=a.xno and
isnull(YHFS_NO,'') LIKE ''
order by a.dtimeselect vip_no,vip_name,sex,hydj_name,dtime,consume,score,yhfs_name,smoney,autoupdate,
address,addinfo,ftel,idcard,born,company,email
from #f
where rowid between 1 and 25我如果选择条件查询的时候 YHFS_NO选择的为空 他能把所有的YHFS_NO为空或者不为空的记录都查出来
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货