改变表结构是不能使用变量名？

[zjfcn]

declare @tmp_function char(20)
select @tmp_function='管理商品'
ALTER TABLE [dbo].[info_privilege] WITH NOCHECK ADD @tmp_function bit not null default (0)

[pengdali]

declare @tmp_function char(20)
select @tmp_function='管理商品'

exec('ALTER TABLE [dbo].[info_privilege] WITH NOCHECK ADD '+@tmp_function+' bit not null default (0)')

[zjfcn]

Thank you very much!