是这样的,我在上一个菜单里面查这个为'807230200004969'这个账户,状态是“账户印鉴更新暂存退出”,可是在账户状态里面查询,就显示不出来这个账户,于是我用SQL追踪,得出了以下语句:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000;SET XACT_ABORT ON ;
insert into seallog (clerkid,departid,operate,operatetime,re)
select '1111111' As Clerkid ,DepartId,311 As operate,GetDate(),'' As re from SealClerk
where clerkID = '1111111' and (Isdelete = 0 or Isdelete is Null)
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000; SET XACT_ABORT ON ;
select a.ActNo,a.Status,a.FrmSFTP,b.ClerkID as OpClerkID,c.OpenBank as OpDepartID,
b.OperateTime as OpDate from ActIndex as a,SealLog as b,SealAct as c
where a.Status=7 and a.indexno=0 and a.ActNo=b.ActNo and b.Operate=1501 And b.OperateTime>='2011-05-18 00:00:00'
And b.OperateTime<='2011-05-18 23:59:59' and a.ActNo=c.ActNo and a.ActInfoID=c.ActInfoID请达人们帮我看下,谢谢~为什么这个807230200004969的账户在状态里面显示不出来,
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000;SET XACT_ABORT ON ;
insert into seallog (clerkid,departid,operate,operatetime,re)
select '1111111' As Clerkid ,DepartId,311 As operate,GetDate(),'' As re from SealClerk
where clerkID = '1111111' and (Isdelete = 0 or Isdelete is Null)
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SET LOCK_TIMEOUT 120000; SET XACT_ABORT ON ;
select a.ActNo,a.Status,a.FrmSFTP,b.ClerkID as OpClerkID,c.OpenBank as OpDepartID,
b.OperateTime as OpDate from ActIndex as a,SealLog as b,SealAct as c
where a.Status=7 and a.indexno=0 and a.ActNo=b.ActNo and b.Operate=1501 And b.OperateTime>='2011-05-18 00:00:00'
And b.OperateTime<='2011-05-18 23:59:59' and a.ActNo=c.ActNo and a.ActInfoID=c.ActInfoID请达人们帮我看下,谢谢~为什么这个807230200004969的账户在状态里面显示不出来,
select a.ActNo,a.Status,a.FrmSFTP,b.ClerkID as OpClerkID,c.OpenBank as OpDepartID,
b.OperateTime as OpDate
from ActIndex as a,
SealLog as b,
SealAct as c
where
a.Status=7
and a.indexno=0
and a.ActNo=b.ActNo
and b.Operate=1501
And b.OperateTime>='2011-05-18 00:00:00'
And b.OperateTime<='2011-05-18 23:59:59'
and a.ActNo=c.ActNo
and a.ActInfoID=c.ActInfoID这样 你把你的where语句全部剪切掉 然后一句一句加上去 看下到哪句的时候查不出数据
另外建议你写成 b.OperateTime between '2011-05-18 00:00:00' and '2011-05-18 23:59:59'