Errata for my book on Querying data with Transact-SQL (MCSA 70-761)

If you find any errors in the book, please let me know. This will help not only myself, but also other readers.

This entry was posted in MCSA SQL 2016 70-761. Bookmark the permalink.

5 Responses to Errata for my book on Querying data with Transact-SQL (MCSA 70-761)

  1. Scott Randle says:

    Hello,
    I passed the Database Fundamentals exam with the help of your first book and am now preparing for the MCSA 70-761. I believe there is an error in chapter 1 as follows:

    — 040
    SELECT 1, ‘record 1’
    UNION
    SELECT 1, ‘record 2’

    SELECT 1, ‘record 1’
    UNION ALL
    SELECT 1, ‘record 2’

    It appears to me from the output examples that there should be no ‘record 2’ instead both SELECTS should read ‘record 1’

    Van den Berg, Robert. 70-761 Querying Data with Transact-SQL: MCSA SQL 2016 exam 70-761 (MCSA: SQL 2016) . Kindle Edition.

    • Robert says:

      Hello Scott,

      You are correct. Both select statements should be identical, in both queries:

      — 040
      SELECT 1, ‘record 1’
      UNION
      SELECT 1, ‘record 1’

      SELECT 1, ‘record 1’
      UNION ALL
      SELECT 1, ‘record 1’

      Only then will the UNION ALL filter out the duplicate record.

      Thank you for the feedback!

      Greetings,

      Robert

  2. Lynn Caveny says:

    You’re using a TestDB database in your examples. It would be nice if you would furnish a backup of that database for us to use!

    • Robert says:

      Hello Lynn,

      Thank you for the feedback. For this test database, I have decided not to provide a backup, but only the code to create all required DDL statements. The reason for this is that, throughout the course of the book, I need different versions of the same object, and I want to explain the DDL code along the way. I believe this provides a better learning experience.

      Greetings,

      Robert

  3. Raimonds Rubikis says:

    — 009
    SELECT master.sys.databases.name
    Returns on SQL 2016 for Windows:
    Msg 4104, Level 16, State 1, Line 1
    The multi-part identifier “master.sys.databases.name” could not be bound.

    SELECT name from master.sys.databases — <- successfully returns data.

Leave a Reply

Your email address will not be published. Required fields are marked *