Viewer

 

05 2008 档案

SQL Server CTE
摘要：Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->----------------嵌套获取员工级别 WITH CTE (EmployeeId,FullName, ManagerId, BossName, EmployeeLevel) AS (... 阅读全文

posted @ 2008-05-30 23:06 Viewer 阅读(299) 评论(0) 推荐(0)

用OVER实现统计
摘要：Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->SELECT TJobNumber, TClientCode, TToChargePounds, SUM(TToChargePounds) OVER(PARTI... 阅读全文

posted @ 2008-05-30 23:04 Viewer 阅读(229) 评论(0) 推荐(0)

SQL Server Ranking Functions
摘要：一共有四个Ranking Function. 作用如下： Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> SELECT EmployeeId, FullName EmployeeName, DepartmentId... 阅读全文

posted @ 2008-05-30 22:47 Viewer 阅读(203) 评论(0) 推荐(0)

用存储过程实现多条件查询的方法
摘要：1. 拼接SQL代码，然后通过EXEC (@SQLString)得到结果。可读性不好，而且如果碰到SQL太长可能会溢出。 2. 今天想到个更好的取巧方法：设置参数的缺省值，然后将判断参数与缺省值是否相等 和 与此参数相关的查询条件 用OR连接 组成一个查询条件： Code highlighting produced by Actipro CodeHighlighter (freeware) ... 阅读全文

posted @ 2008-05-03 03:14 Viewer 阅读(843) 评论(5) 推荐(0)

导航