update qualityMonitoringGoods set tousseDefinitionId =
(
select tousseDefinition_id from TousseInstance where id=convert(int,qualityMonitoringGoods.tousseInstanceId) 
)
where tousseInstanceId is not null and tousseInstanceId<>'' and tousseDefinitionId is null;