--开始更新
UPDATE
a SET a.ProviderTypeNames=b.ProviderTypeNameList
FROM fy_Provider a
INNER JOIN [IP2].[数据库名].dbo.p_Provider b ON a.ProviderGUID=b.ProviderGUID
WHERE a.ProviderTypeNames<>b.ProviderTypeNameList AND a.IsLock=1
