如何重用通用表表达式

如果您在2个不同的查询中都不要求使用它们，则可以尝试

;with query as (  Select Row_Number() over (Order By UserID ASC) as TableRowNum,         FirstName,         LastName  From   Users),totalCount AS (    SELECt COUNT(1) Total FROM query)Select  query.*,        Totalfrom    query, totalCount where   TableRowNum between 1 and 25 Order By TableRowNum ASC

如果确实需要2个不同的查询，请使用表var

DECLARE @User TABLE(        TableRowNum INT,        FirstName VARCHAr(50),        LastName VARCHAr(50));with query as (  Select Row_Number() over (Order By UserID ASC) as TableRowNum,         FirstName,         LastName  From   Users)INSERT INTO @UserSELECt  TableRowNum,        FirstName,        LastNameFROM    querySELECt  *FROM    @Userwhere   TableRowNum between 1 and 25 Order By TableRowNum ASCSELECt COUNT(1) FROM @User