sql server 表数据循环拼接update语句

SELECT STUFF((SELECT ';UPDATE Base SET NAME = '''+NAME+''' WHERE SchoolId = '''+Id+'''' FROM School FOR XML PATH ('')),1,1,'')

将对应表名和字段改为自己要用的即可。