In SQL Azure there are cases where the use of Select Into is needed when used with temporary tables. Many times it is more performant to Select Into #temptable, then Truncate sourcetable, then insert into sourcetable from #temptable. Additionally by allowing Select Into #temptable developers avoid coding in the create table structure of the temp table to match the sourcetable. This way when the sourcetable structure changes the #temptable follows suit without the need to go revisit create table #temptable code.
Product Language
Category
Proposed Solution
Primary Benefit
Other Benefits
Virtualization