可以采用exec方法
declare @tempstr varchar(350)
select @tempstr='update weekcount set [' convert(varchar,@week) ']=[' convert(varchar,@week) '] 1 where
userid=''' replace(@user,'''','''''') ''''
exec(@tempstr)
注意: 使exec不能返回一些变量的值,而且当前的变量值在exec的语句里无效.
http://www.bkjia.com/phpjc/631206.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/631206.htmltecharticle可以采用exec方法 declare @tempstr varchar(350) select @tempstr='update weekcount set [' convert(varchar,@week) ']=[' convert(varchar,@week) '] 1 where userid=''' replace(@user...