declare @orderby VarChar(20)
set @orderby='表的字段名'
declare @sql varchar(2000)
set @sql='select * from table order by '+@orderby+' asc'
exec (@sql)
set @orderby='表的字段名'
declare @sql varchar(2000)
set @sql='select * from table order by '+@orderby+' asc'
exec (@sql)
declare @orderby VarChar(20)
set @orderby='表的字段名'
exec ('select * from table order by ' + @orderby + 'asc')
set @SQL='select * from table order by '+@orderby+' asc'
exec(@SQL)
set @orderby='表的字段名'
exec('select * from table order by ' + @orderby + ' asc')
set @orderby='表的字段名'exec('select *
from table
order by '+@orderby+' asc')