Articles tagged common-table-expressions

  1. How to Write Secure SQL Common Table Expressions

    Nickolas Fisher Nickolas Fisher

    5 min read

    Common table expressions are a powerful feature of Microsoft SQL Server. They allow you to store a temporary result and execute a statement afterward using that result set. These can be helpful when trying to accomplish a complicated process that SQL Server isn't well suited to handle. CTEs allow you…

    Read more