update [SQL_TMC_TMS].[dbo].[ClassRecords]

set userid=(select top 1 ISNULL(id,0) from [SQL_TMC_TMS].[dbo].[Student] where [IDNumber]=[SQL_TMC_TMS].[dbo].[ClassRecords].[IDNumber])

where ([LessonID]='115'  and userid=0

and idnumber in (select idnumber from [SQL_TMC_TMS].[dbo].[Student] ))

update [FYCMS_XTLJ].[dbo].[Student]

set isDel=(select top 1 case IsDel when 'Y' then 1 when 'N' then 0 else 0 end from [TMC_TMS].[dbo].[Student] where [TMC_TMS].[dbo].[Student].UserID=[FYCMS_XTLJ].[dbo].[Student].id)