declare @sql nvarchar(4000)
if @sortName = ''
set @sortName= 'CommodityTypeId'
if @sortType = ''
set @sortType = 'Asc'
set @sql='
select *,Alltypename=dbo.f_fullname(commoditytypeid) from t_INSMCommodityType
where enable=1
order by '+@sortName+ ' ' +@sortType + '
'
exec SP_EXECUTESQL @sql
GO