老实巴交的搬砖户

摘要： DECLARE @sqlTabName varchar(100);-- 声明游标DECLARE C_Employees CURSOR FAST_FORWARD FOR SELECT TableName FROM BdItem --表名配置表 OPEN C_Employees;-- 取第一条记录FET 阅读全文

摘要： SELECT STUFF((SELECT ';UPDATE Base SET NAME = '''+NAME+''' WHERE SchoolId = '''+Id+'''' FROM School FOR XML PATH ('')),1,1,'') 将对应表名和字段改为自己要用的即可。 阅读全文