clear markdown compare help best fiddles feedback
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2801143 fiddles created (40104 in the last week).

DECLARE @Pagesize int, @Page int; declare @StartingRow int; declare @EndingRow int; if @Pagesize = 0 begin select @StartingRow = (@PageSize * (@Page - 1)); select @EndingRow = (@StartingRow + @PageSize + 1); end else begin set @StartingRow = 0; set @EndingRow = 999999; end; WITH ParentHierarchy AS( SELECT 1 AS I) SELECT I FROM ParentHierarchy;
 hidden batch(es)