请教大侠:
我有触发器部分代码如下:
..............
IF Exists(
select i.GUID
from inserted i
inner join deleted d on d.GUID = i.GUID
inner join SD_SaleRecp_M SR on SR.sSaleRecpCode = i.sItemCode
where SR.sSaleTypeID = '20020001'
and IsNull(d.sSynchroStatus, '1') = '0' and IsNull(i.sSynchroStatus, '0') = '1'
and IsNull(i.sReverseCauseID, '') = '' and IsNull(d.sReverseCauseID, '') = ''
)
BEGIN
update SM_FinalFabricOut_M
set sStatusID = '2',
sInvoiceNO = i.sItemCode,
dIncomeDate = i.dTallyDate
from inserted i
inner join deleted d on d.GUID = i.GUID
inner join SD_SaleRecp_M SR on SR.sSaleRecpCode = i.sItemCode
inner join SD_SaleRecp_D1 SRD on SRD.SD_SaleRecp_MGUID = SR.GUID
inner join SD_ShipNote_M SN on SN.GUID = SRD.SD_ShipNote_MGUID
where SM_FinalFabricOut_M.sBillCode = SN.sSerialNO
and SR.sSaleTypeID = '20020001'
and IsNull(SM_FinalFabricOut_M.sStatusID,'2') = '1'
and IsNull(d.sSynchroStatus, '1') = '0' and IsNull(i.sSynchroStatus, '0') = '1'
and IsNull(i.sReverseCauseID, '') = '' and IsNull(d.sReverseCauseID, '') = ''
......................................................
我的触发器执行 inserted :dIncomeDate = i.dTallyDate 的时候,
i.dTallyDate偶尔写入的时间是:1900-01-01 00:00:00.000 查库里面还有不少这样的时间,应该写入inserted实时时间
找了好久也没找到为什么。
有没有解决的方法,请各位大侠赐教!
我有触发器部分代码如下:
..............
IF Exists(
select i.GUID
from inserted i
inner join deleted d on d.GUID = i.GUID
inner join SD_SaleRecp_M SR on SR.sSaleRecpCode = i.sItemCode
where SR.sSaleTypeID = '20020001'
and IsNull(d.sSynchroStatus, '1') = '0' and IsNull(i.sSynchroStatus, '0') = '1'
and IsNull(i.sReverseCauseID, '') = '' and IsNull(d.sReverseCauseID, '') = ''
)
BEGIN
update SM_FinalFabricOut_M
set sStatusID = '2',
sInvoiceNO = i.sItemCode,
dIncomeDate = i.dTallyDate
from inserted i
inner join deleted d on d.GUID = i.GUID
inner join SD_SaleRecp_M SR on SR.sSaleRecpCode = i.sItemCode
inner join SD_SaleRecp_D1 SRD on SRD.SD_SaleRecp_MGUID = SR.GUID
inner join SD_ShipNote_M SN on SN.GUID = SRD.SD_ShipNote_MGUID
where SM_FinalFabricOut_M.sBillCode = SN.sSerialNO
and SR.sSaleTypeID = '20020001'
and IsNull(SM_FinalFabricOut_M.sStatusID,'2') = '1'
and IsNull(d.sSynchroStatus, '1') = '0' and IsNull(i.sSynchroStatus, '0') = '1'
and IsNull(i.sReverseCauseID, '') = '' and IsNull(d.sReverseCauseID, '') = ''
......................................................
我的触发器执行 inserted :dIncomeDate = i.dTallyDate 的时候,
i.dTallyDate偶尔写入的时间是:1900-01-01 00:00:00.000 查库里面还有不少这样的时间,应该写入inserted实时时间
找了好久也没找到为什么。
有没有解决的方法,请各位大侠赐教!
这个表插入记录的时候,插入了空值什么的,就是1900....