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 中要怎么改在线等,马上结贴
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%'
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%'
很简单的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%'
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%'
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%'
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%'
不对,是这样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%'
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%'
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%'
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%'
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%'
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%'
from [fm_Content] a Left Join [fm_Column] b
on a.columnId=b.id
where a.columncode like '0004%'
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%'
from [fm_Content] a (Left Join [fm_Column] b
on a.columnId=b.id)
where a.columncode like '0004%'
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%'