Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 2: Writing Subqueries RE: Stairway to T-SQL Part 2: Beyond T-SQL Basics: Level 2: Writing Subqueries

  • September 6, 2016 at 11:19 am

    #1899413

    jetboy2k (9/5/2016)

    What other Stairways should one take prior to this one? There's a reference to the Stairway to T-SQL DML Stairway, which I've finished, but in this article, there is also this statement:

    Here are some other things to consider when using a subquery:

    ntext, text and image data types are not allowed to be returned from a subqueries

    The ORDER BY clause cannot be used in a subquery unless the TOP operator is used

    Views that use a subquery can’t be updated

    COMPUTE and INTO clauses cannot be used in a subquery

    However, I've done a search on all of the Stairway to T-SQL DML articles, and there is no mention or example of the COMPUTE clause. Is there another Stairway to read prior to this one? Or is there a basic set of T-SQL commands we should know prior to starting this one?

    I'm guessing that he's just listing all clauses that cannot be used in a subquery. Since COMPUTE is a clause that exists, and cannot be used in a subquery, it's included in the list. I don't think he's trying to imply that it's a clause that you should already know all about. 🙂