update Books_Temp set vIndexUrl=t2.vIndexUrl,vAuthor=t2.vAuthor,vLastHref=t2.vLastHref,vLastTitle=t2.vLastTitle,vCharpters=t2.vCharpters from Books_Temp t1 inner join Temp t2 on t2.vid=t1.vid
更新语句如下:update Books_Temp set vIndexUrl=t2.vIndexUrl,vAuthor=t2.vAuthor,vLastHref=t2.vLastHref,vLastTitle=t2.vLastTitle,vCharpters=t2.vCharpters from Books_Temp t1 inner join Temp t2 on t2.vid=t1.vid 这个语句执行后会返回受影响的行数(Temp表的行数),但诡异的是,Books_Temp表有时候会只更新