select REPLACE(Description,char(13) + char(10),'<br/>')as Description from tablename 转载于:https://www.cnblogs.com/ylemzhang/archive/2009/12/22/1629757.html