[Proposal] SqlServer2012 grammar file

[crissi]

That implements limit and offset with sql server 2012's: OFFSET AND FETCH instead of row_number() over

[GrahamCampbell]

Any thoughts?

[stevenobird]

Well, that "should" be pretty easy.

In SqlServerGrammar.php:

    protected function compileOffset(Builder $query, $offset)
    {
        return "OFFSET {$offset} ROWS";
    }

    protected function compileLimit(Builder $query, $limit)
    {
        return "FETCH {$limit} ROWS ONLY";
    }

The thing is, that OFFSET can be used alone, but FETCH needs a leading OFFSET Clause in order to work.

Also, the used SQL Server Version should be specified in the Database.php config file in order to avoid conflicts, since this OFFSET Syntax has just been introduced in SQL Server 2012 (which is in version terms, 11.0).

[GrahamCampbell]

We're open to PRs.

[yansern]

I attempted to implement OFFSET...FETCH but it only take effect when ->orderBy is used. Otherwise it will fallback to ROW_NUMBER().

Gist: https://gist.github.com/yansern/4d7017351314eb37fa0df284ccd51c40
Feel free to diff it yourself to see what's changed.

This is for the file: src/Illuminate/Database/Query/Grammars/SqlServerGrammar.php.

Perhaps this can be a starting point for others to follow.