create proc cc @chang varchar(10)
as
exec('select '+@chang+' from 成绩')or
create proc cc @chang varchar(10)
as
declare @sql varchar(4000)
set @sql='select '+@chang+' from 成绩'
exec(@sql)exec cc 数学
as
exec('select '+@chang+' from 成绩')or
create proc cc @chang varchar(10)
as
declare @sql varchar(4000)
set @sql='select '+@chang+' from 成绩'
exec(@sql)exec cc 数学
as exec('select '+@chang+' from 成绩')
exec cc '数学'