By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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 ''.
declare @p int = 0;
select *
from(values(0),(1),(2))f(x)
order by 1
offset 0 rows
fetch next @p rows only
| x |
|---|
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.