我实在想不出为什么老出这个错,高手们,大侠们指点一下吧
谢谢了,我把表[shijiMatch ] as a ;[TeachingPractise] as b 也是这种错误
update shijiMatch
set [shijiMatch].[id]=[EduDragon].dbo.TeachingPractise.[id]select* from[EduDragon.Test].dbo.shijiMatch inner join [EduDragon].dbo.[TeachingPractise ]
on [EduDragon].dbo.[TeachingPractise].textid= [shijiMatch].datacode
and Cast([EduDragon].dbo.TeachingPractise.summary as varchar(70)) =[shijiMatch].name
错误:
消息 4104,级别 16,状态 1,第 1 行
无法绑定由多个部分组成的标识符 "EduDragon.dbo.TeachingPractise.id"。
谢谢了,我把表[shijiMatch ] as a ;[TeachingPractise] as b 也是这种错误
update shijiMatch
set [shijiMatch].[id]=[EduDragon].dbo.TeachingPractise.[id]select* from[EduDragon.Test].dbo.shijiMatch inner join [EduDragon].dbo.[TeachingPractise ]
on [EduDragon].dbo.[TeachingPractise].textid= [shijiMatch].datacode
and Cast([EduDragon].dbo.TeachingPractise.summary as varchar(70)) =[shijiMatch].name
错误:
消息 4104,级别 16,状态 1,第 1 行
无法绑定由多个部分组成的标识符 "EduDragon.dbo.TeachingPractise.id"。
将Where条件的记录看一下是否唯一,若有多条,当然不好值
例如:
update shijiMatch
set [shijiMatch].[id]=[EduDragon].dbo.TeachingPractise.[id]
where [shijiMatch].name=[EduDragon].dbo.TeachingPractise.name