Update S Set ConArr_OrdRec_sta=123 From Stat_cyc_OrdVeh S , CommonAttribute C Where VehID=? and (S.Val_time is not null) and (C.vali_fDate<=convert(int,convert(Varchar(20) ,S.Val_time,112))) --这里少两个括号 and convert(int,convert(Varchar(20) ,S.Val_time,112))<=C.vali_TDate and C.attr='ddsxsj'
Set
ConArr_OrdRec_sta=123
From Stat_cyc_OrdVeh S , CommonAttribute C
Where
VehID=?
and
(S.Val_time is not null)
and
(C.vali_fDate<=convert(int,convert(Varchar(20) ,S.Val_time,112))) --这里少两个括号
and
convert(int,convert(Varchar(20) ,S.Val_time,112))<=C.vali_TDate
and
C.attr='ddsxsj'
虽然不是这个错误!分给你了!