update a
set permitGroups=null
from news.dbo.article a ,aClass c
where a.classid=c.classid and c.parentID=19
set permitGroups=null
from news.dbo.article a ,aClass c
where a.classid=c.classid and c.parentID=19
a
set
permitGroups=null
from
news.dbo.article a
inner join
aClass c
on
a.classid=c.classid
where
c.parentID=19
on a.classid=c.classid
where c.parentID=19
set permitGroups=null
from news.dbo.article t
join aClass c
on t.classid=c.classid
where c.parentID=19
aClass应该是news.dbo.aClass
但是所有人的语句都是
(所影响的行数为 0 行)