数据列名，怎样写

[Aden]

有一列:CountM7 数据类型是int

数字7为当前月份,
我怎样动态修改呢?
declare @mTemp varchar(10)
select @mTemp = 'CountM' + Convert(varchar(2),MONTH (getdate()) )

update Count_Year set @mTemp = @mTemp + 1 where CountYear = year(getdate())

这里两个@mTemp = @mTemp 提示错误

错误在第二个@mTemp这里，
直接写成：
update Count_Year set @mTemp = CountM7+ 1 where CountYear = year(getdate())

就可以,该怎样修改？

[hellowork]

declare @sql varchar(4000)
set @sql = 'update Count_Year set CountM' + Convert(varchar(2),MONTH(getdate())) +
' = CountM' + Convert(varchar(2),MONTH(getdate())) + ' + 1 where CountYear = year(getdate())'
--print @sql
exec(@sql)

[LouisXIV]

--try

declare @mTemp varchar(10)
select @mTemp = 'CountM' + Convert(varchar(2),MONTH (getdate()) )

exec('update Count_Year set '+@mTemp+' = '+@mTemp+' + 1 where CountYear = year(getdate())')

[Aden]

结帖