clear markdown compare help best fiddles feedback dbanow.uk
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. 2591499 fiddles created (45733 in the last week).

select * from(values(0),(1),(2))f(x) order by 1 offset 0 rows fetch next 0 rows only'
Msg 105 Level 15 State 1 Line 5 Unclosed quotation mark after the character string ''.
 hidden batch(es)


declare @p int = 0; select * from(values(0),(1),(2))f(x) order by 1 offset 0 rows fetch next @p rows only
x
 hidden batch(es)


declare @p int = 0,@o int = 0; select * from(values(0),(1),(2))f(x) order by 1 offset @o rows fetch next @p rows only
Msg 10744 Level 15 State 1 Line 2 The number of rows provided for a FETCH clause must be greater then zero.
 hidden batch(es)