Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/1 0:17:10
SQL语句过滤字符_[SQL，Server教程]

SQL语句过滤字符_[SQL Server教程]

SELECT (case
WHEN LEN(NewsID) > 10 then LEFT(NewsID,8) + '...'
ELSE
NewsID
END
) AS NewsTitle
FROM YourTable
输出直接用<%# DataBinder.Eval(Container.DataItem,"NewsTitle")%>




赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759