随笔分类 - SQLServer

数据库相关

摘要：在sql2005加入了cte实现sql递归，大致语法如下：WITH batchTable(batch) AS( select 8000 batch UNION ALL SELECT batch+1 from batchTable where batch+1<8180)select * from batchTableOPTION (MAXRECURSION 1000)要点一：实现递归查询一定要有递归出口，否则就成了死循环了要点二：OPTION (MAXRECURSION 1000) 规定最大的递归次数为1000 阅读全文

posted @ 2011-03-29 15:49 Shiaupo 阅读(489) 评论(0) 推荐(0)

SQL日期格式转换大全

摘要：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECTCONVERT(varchar(100),GETDATE(),0):0516200610:57AMSELECTCONVERT(varchar(100),GETDATE(),1):05/16/06SELECTCONVERT(varchar(100),GETDATE(),2):06.05.16SELECTCONVERT(varchar(100),GETDATE(),3):16/05/06 阅读全文

posted @ 2010-12-30 17:19 Shiaupo 阅读(242) 评论(0) 推荐(0)