阅读背景:

在sql查询中强制限制计数(*)

来源:互联网 

I am using a subquery to return a count as an integer value to my main query. This query is used to rebind an ASP.NET DataGrid and I have only two characters width available for this column. I want to restrict the width to two characters. So, I want to set a value of 99 when the count exceeds 99. I can't figure a way to do this? I can't see how to apply a case statement here.I am using a subquery to return a count as an i




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: