Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield SELECT * usage RE: SELECT * usage

  • May 10, 2012 at 1:09 am

    #1485492

    Good question, Wayne. And thanks Koen for the additional reference.

    Also, the result set in the explanation is not really correct. The ColumnSet row will display XML data. I assume that the internet interface of the website somehow has stripped a lot of the XML tags embedded in that result set. I encourage everyone to copy, paste and execute the demo code posted by Wayne.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/