1前景:实现存储过程的动态排序,不是对列进行动态排序,而是根据动态的改变asc或者desc 代码如下: declare @sort varchar(10) select @sort ='0' if (@sort='1') begin select counter.id, businessNum,replace( replace( convert(varchar(10),exportTime,102),datename(yyyy,exportTime)+'.','')+datename(dw,exportTime),+'星期','')as exportTime,shipSide,shipOwner,destinationPort,forwarder,addressLation, replace( replace( convert(varchar(20),arrivalTime,102),datename(yyyy,arrivalTime)+'.','')+datename(dw,arrivalTime)+datename(hh,arrivalTime),'星期','')as arrivalTime,billNum,containerType,containerNum,seal,customFee,trucking,forwarderFee,otherfee,hexiao,closeBill,commodity,customAmount,billAmount,rebateRate,rebateAmount,rebateNum,specialNum,isComment,color from counter,memory where counter.id = bsId and