这句错在哪里update (select top 2 * from HPTraceCode where planid=15 and state='2' order by bodyCode DESC) set state='1'
寒雪叔叔 2005-10-07 08:23:01 我只想将符合条件的记录的前两条进行UPDATE操作
update (select top 2 * from HPTraceCode where planid=15 and state='2' order by bodyCode DESC) set state='1'
请问错在哪里,在SQL SERVER里不能执行,而在ACCESS里好象就可以