急 ，看下这个sql语句，马上结贴

[jingcai]

update [fm_Content] a Left Join [fm_Column] b on a.columnId=b.id set a.columnCode=b.code,a.columnName=b.title where a.columncode like '0004%'

上面的在access中可以正常执行

请问我要移植到sqlserver 中要怎么改

在线等，马上结贴

[Lxpd]

update a
set a.columnCode=b.code,a.columnName=b.title

From [fm_Content] a Left Join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'

[wxg22526451]

SQL用update..from

update a set a.columnCode=b.code,a.columnName=b.title 
from [fm_Content] a Left Join [fm_Column] b 
on a.columnId=b.id where a.columncode like '0004%' 

[damo_baby]

很简单的

update a
set a.columnCode=b.code
,a.columnName=b.title
From [fm_Content] a
Left join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'

[miraxcx]

update a
set a.columnCode=b.code
,a.columnName=b.title
From [fm_Content] a
Left join [fm_Column] b on a.columnId=b.id
where a.columncode like '0004%'

[wangchao813]

update a set a.columnCode=b.code,a.columnName=b.title
from [fm_Content] a Left Join [fm_Column] b
on a.columnId=b.id
where a.columncode like '0004%'

[tddw]

ACCESS的Left Join要带括号(因为多表连查时是这样的)，这样写试试（我没测试正确性）

update [fm_Content] a (Left Join [fm_Column] b on a.columnId=b.id) set a.columnCode=b.code,a.columnName=b.title where a.columncode like '0004%'

[tddw]

不对，是这样

update a set a.columnCode=b.code,a.columnName=b.title
from [fm_Content] a (Left Join [fm_Column] b
on a.columnId=b.id)
where a.columncode like '0004%' 

[CloudOfFly]

[Quote=引用 7 楼 tddw 的回复:]
不对，是这样

SQL code
update a set a.columnCode=b.code,a.columnName=b.title
from [fm_Content] a (Left Join [fm_Column] b
on a.columnId=b.id)
where a.columncode like '0004%'
[/Quote]

[levinstong]

update a
set a.columnCode=b.code ,a.columnName=b.title
From [fm_Content] a
Left join [fm_Column] b
on a.columnId=b.id
where a.columncode like '0004%'

[若灵思源]

同意1楼观点

[a27621165]

哇哈哈 都是大牛啊

来晚了 ！！！

[DiscussQuestions]

2楼已经说的很清楚啦！~
来的太晚了！~呵呵