用动态SQL语句: declare @mm char(2),@sql varchar(4000) select @mm='1' set @sql='update jt_c1sfc04 set rks'+@mm+'=b.rks from jt_c1sfc04 a,jt_clkcmx1 b where a.pzdm=b.pzdm' exec(@sql)
DECLARE @mm varchar(2),@sql varchar(8000) SELECT @mm = '1' SET @sql = 'UPDATE jt_c1sfc04 SET rks' + @mm + ' = b.rks FROM jt_c1sfc04 a,jt_clkcmx1 b WHERE a.pzdm=b.pzdm' -- PRINT @sql -- 打印测试 EXEC (@sql)
declare @mm char(2),@sql varchar(4000)
select @mm='1'
set @sql='update jt_c1sfc04 set rks'+@mm+'=b.rks from jt_c1sfc04 a,jt_clkcmx1 b where a.pzdm=b.pzdm'
exec(@sql)
SELECT @mm = '1'
SET @sql = 'UPDATE jt_c1sfc04 SET rks' + @mm + ' = b.rks FROM jt_c1sfc04 a,jt_clkcmx1 b WHERE a.pzdm=b.pzdm'
-- PRINT @sql -- 打印测试
EXEC (@sql)