27,579
社区成员
发帖
与我相关
我的任务
分享
update
a
set
a.leibie=54
from
jwc2011.[dbo].news2 a,jwc.[dbo].news b
where
a.title=b.News_Title and b.[Index]=1
update a set a.leibie=54
from jwc2011.[dbo].news2 a,jwc.[dbo].news b
where a.title=b.News_Title and b.[Index]=1
update a set a.leibie=54
from jwc2011.[dbo].news2 a,jwc.[dbo].news b
where a.title=b.News_Title and b.[Index]=1
--#1.
UPDATE jwc2011.[dbo].news2
SET leibie = 54
FROM jwc2011.[dbo].news2 a, jwc.[dbo].news b
WHERE a.title = b.News_Title
AND b.[Index] = 1
--#2.
UPDATE A
SET leibie = 54
FROM jwc2011.[dbo].news2 A, jwc.[dbo].news B
WHERE A.title = B.News_Title
AND B.[Index] = 1