摘要:
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 程旭圆 阅读(140) 评论(0) 推荐(0) 编辑
|
|||
摘要:
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 程旭圆 阅读(140) 评论(0) 推荐(0) 编辑
摘要:
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 程旭圆 阅读(625) 评论(0) 推荐(0) 编辑 |
|||