摘要： 1. Get only date part for comparing. FLOOR(CAST(GETDATE() AS FLOAT)) 2. Paging DECLARE @PageNum intDECLARE @PageSize intSET @PageNum = 2SET @PageSize = 20;WITH cte AS( SELECT tbl.*, ROW_NUMBER() OVER(... 阅读全文