随笔分类 -  SQL

ROW_NUMBER
摘要：ROW_NUMBER() OVER(PARTITION BY COLUMN ORDER BY COLUMN) 阅读全文

posted @ 2014-03-19 15:16 zicheng_307 阅读(158) 评论(0) 推荐(0)

SQL 关键字 for xml path
摘要：其实它就是将查询结果集以XML形式展现，有了它我们可以简化我们的查询语句实现一些以前可能需要借助函数活存储过程来完成的工作SELECT SheetID,LEFT(NameLst,LEN(NameLst)-1) AS Names FROM ( SELECT SheetID,( SELECT EmployeeName+',' FROM T_WO_RepairSheetEquipMaintainer (NOLOCK) INNER JOIN T_BD_SupplierMaintanceInfo ON T_WO_RepairSheetEquipMaintainer.MaintainerI 阅读全文

posted @ 2014-03-11 09:44 zicheng_307 阅读(235) 评论(0) 推荐(0)

SQL 关键字 With
摘要：Create TABLE tab (CurNum VARCHAR(10),PreNum VARCHAR(10))INSERT INTO tabSELECT '1', Null UNION ALL SELECT '2', '1' UNION ALL SELECT '3', '2' UNION ALL SELECT '4', '1' UNION ALL SELECT '5', Nullselect * from tabSELECT CurNum,PreNum,path=C 阅读全文

posted @ 2014-02-26 20:16 zicheng_307 阅读(200) 评论(0) 推荐(0)

SQL 关键字
摘要：-- quotename : 使字符串变成标识符select quotename('abc[]def')select quotename('abc[]def','''')select quotename('abc[]def','[')select quotename('abc[]def',']')select quotename('abc[]def','"')-- CHOOSE：从序列中选择第X个数据SELECT x,CHOO 阅读全文

posted @ 2014-02-24 19:40 zicheng_307 阅读(84) 评论(0) 推荐(0)