Contents tagged with Imperative

  • Logical sequence of T-SQL operations

    Hello everybody,

    Today I want to note that SQL Server has following order of processing:

    From

    Where

    Group by

    Having

    Select

    [Expressions]

    [Distinct]

    Order By

    [TOP/OFFSET-FETCH]

    By looking on this order you may understand why in C# LINQ from goes first and not select. That is because C# is imperative language, while SQL is declarative. more