Spiral\Database\Drivers\SQLServer\SQLServerCompiler::compileLimit()

Complexity

Conditions	4
Paths	3

Size

Total Lines	15
Code Lines	7

Duplication

Lines	15
Ratio	100 %

Importance

Changes

0

<?php
    protected function compileLimit(int $limit, int $offset): string

This method seems to be duplicated in your project.

    {
        if (empty($limit) && empty($offset)) {
            return '';
        }

        //Modern SQLServer are easier to work with
        $statement = "OFFSET {$offset} ROWS ";

        if (!empty($limit)) {
            $statement .= "FETCH NEXT {$limit} ROWS ONLY";
        }

        return trim($statement);
    }
}