尝试直接去insert/update的时候出错,放到事务中就成功了。
begin tran
exec padvauditeventadmin
update AdvFactorHistory
set FactorValue = '0.55'
where SecurityID = '1567' and ThruDate like '1998-10%'
exec padvauditeventend
commit tran
尝试直接去insert/update的时候出错,放到事务中就成功了。
begin tran
exec padvauditeventadmin
update AdvFactorHistory
set FactorValue = '0.55'
where SecurityID = '1567' and ThruDate like '1998-10%'
exec padvauditeventend
commit tran