BEGIN
update taxi
set taxi.state = i.state,
taxi.year = i.outyear,
taxi.month = i.outmonth,
taxi.day = i.outday,
taxi.time = i.time
from ( taxi t,Inserted i )
where t.tid = i.tid
SET NOCOUNT ON;END在查询分析器里总是说红色那句附近有语法错误,求助各位大侠~~
update taxi
set taxi.state = i.state,
taxi.year = i.outyear,
taxi.month = i.outmonth,
taxi.day = i.outday,
taxi.time = i.time
from ( taxi t,Inserted i )
where t.tid = i.tid
SET NOCOUNT ON;END在查询分析器里总是说红色那句附近有语法错误,求助各位大侠~~
update t
set t.state = i.state,
t.year = i.outyear,
t.month = i.outmonth,
t.day = i.outday,
t.time = i.time
from taxi t,Inserted i
where t.tid = i.tid
2.from ( taxi t,Inserted i ) 删除两个括号