It's converting your variables, because `bigint` is what `OFFSET ... FETCH` is expecting for those values. It probably makes sense to DECLARE @paramPageNumber AS BIGINT, @paramPageSize AS BIGINT; to avoid any possible performance issues this may cause. Your `id` column in your table, however, should still be fine as an `int`.