SQL Azure - Add support for Select Into for temporary tables - by Dave Williamson2

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 774356 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/14/2012 5:17:13 AM
Access Restriction Public


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.
Sign in to post a comment.
Posted by Umachandar Jayachandran - MS on 8/27/2015 at 7:50 AM
Please note that this suggestion item is specific to V2 servers in Azure SQL Database. If you upgrade the server to V12 then you get almost full T-SQL compatibility with SQL Server 2014 T-SQL surface area and more. See article below for list of unsupported/partially supported in V12.

Posted by Microsoft on 4/25/2013 at 10:00 AM
Hello Dave,
I am resolving this as duplicate of below:


Umachandar, SQL Programmability Team
Posted by Microsoft on 2/27/2013 at 4:25 PM
Hello Dave,

Thanks for your feedback. We are aware of the T-SQL feature disparity between SQL Azure & SQL Server (2005 and upwards). We are tracking all of these features internally. But right now, we have no plans to address the feature difference.

Umachandar, SQL Programmability Team