摘要：例如以下情况，假如字段3是日期类型，按照小时分组统计字段1为空的个数，并对字段2大于5的值求和： SELECT SUM(CASE WHEN field1 IS NULL THEN 1 ELSE 0 END) AS field1count,SUM(CASE WHEN field2>5 then fie
阅读全文
posted @ 2017-01-03 19:51
01 2017 档案
摘要：function FromSort(left, right, asc) { if (left.属性1 != "") { if (right.属性1 != "") { return left.属性1 == right.属性1 ? 0 : (left.属性1.localeCompare(right.属性
阅读全文
posted @ 2017-01-02 20:33
摘要：SELECT field1,field2 FROM table1 AS aOUTER APPLY(SELECT TOP 1 field3,field4 FROM table2 WHERE field3=a.field1)AS b
阅读全文
posted @ 2017-01-02 20:23
摘要：首先添加列：<asp:ButtonColumn Text="选择" CommandName="Select" Visible="False"></asp:ButtonColumn> 其次在ItemDataBound事件中加入单击行脚本：e.Item.Attributes.Add("OnClick",
阅读全文
posted @ 2017-01-02 19:53
