摘要：这次是SQL递归1 WITH Seq (num) AS 2 (SELECT 13 UNION ALL 4 SELECT num + 15 FROM Seq 6 WHERE num <= 50 7 ) 8 SELECT num9 FROM Seq比较难以理解，正如标题：要想理解递归，先得理解递归！ 阅读全文

摘要：今天在用SQL Server查询以prm_开头的表名时发现问题，查看一下是下划线没被转义，特此总结一下T-SQL字符转义创建临时表，插入示例数据1 CREATE TABLE #characters(ch VARCHAR(200))2 INSERT #characters VALUES('[入职时间]:2012-9-12')3 INSERT #characters VALUES('prm_batch')4 INSERT #characters VALUES('select PromiseTime as ''ptime''&# 阅读全文

摘要：先假设有表a、b如下：表a 表b------------------------------------------------------| symbol| sname||symbol |tdate | tclose |---------------------------------------------------------------|A| B|| A| C| D ||G| H| | X| E| F |--------------------------------------------------------------内联接：SELECT a.symbol , a.sn... 阅读全文