摘要： 分页存储过程代码Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--1setANSI_NULLSON2setQUOTED_IDENTIFIERON3go45CreatePROCEDURE[dbo].[ShowPage]6@tblNamevarchar(25... 阅读全文

摘要： 获取当前月一共几天（1）DECLARE @NOW DATETIMEDECLARE @LastDayOfThisMonth DATETIME SET @NOW = GETDATE()--SET@LastDayOfThisMonth = DATEADD(MONTH, 1, @NOW - DAY(@NOW) + 1) - 1SET @LastDayOfThisMonth = DATEADD(MONTH,... 阅读全文

摘要： row_number() over(partition by ... order by ...)P+LEc/{r0rank() over(partitionby ... order by ...)(Y'u­`vL8p$P^? U0dense_rank()over(partition by ... order by ...)!v C.e1F Nx C,f0count()over(part... 阅读全文