declare @nonode table (ID int IDENTITY(1,1),PID int,usered tinyint,checked tinyint,intlen int,lastpoint int)update @nonode set lastpoint=c.id from map_roadinfo a,@nonode b,@nonode c where a.idmin=b.PID and a.idmax=c.PID and b.id=@SNO总是提示 表 '@nonode' 不明确。我写错了么?
--try
update
b
set
lastpoint=c.id
from
map_roadinfo a,@nonode b,@nonode c
where
a.idmin=b.PID and a.idmax=c.PID and b.id=@SNO
set lastpoint=c.id
from map_roadinfo a,@nonode b,@nonode c
where a.idmin=b.PID and a.idmax=c.PID and b.id=@SNO