Post reply

CTE DML

  • July 22, 2014 at 8:42 pm

    #288873

    Comments posted to this topic are about the item CTE DML

  • July 23, 2014 at 1:40 am

    #1731653

    What are the benefits of this script? I mean does it have any use case?

  • July 24, 2014 at 4:58 pm

    #1732218

    Why on earth would anyone want to do this? The scope of a temp table can actually give it a longer life span than a cte which is only "defined within the execution scope of a single SELECT, INSERT, UPDATE, MERGE, or DELETE statement". On the other hand temp tables are typically created in 2 steps while cte's can be created in one. There are clearly uses for both temp tables and cte's but not as data sources for one another.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply