CTE DML

  • Comments posted to this topic are about the item CTE DML

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

  • 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