Home Forums SQL Server 2008 T-SQL (SS2K8) Alternative UPDATE Syntax RE: Alternative UPDATE Syntax

  • April 16, 2013 at 1:44 am

    #1606722

    Have a look at the query shown in the first post of this thread. There are no aliases on the output columns so we can't tell which columns come from which tables. We have to ask or guess.

    Although not always essential for SQL Server, the aliases are information for anyone reading the query. Why would you want to deliberately withhold information?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden