azure不支持哪些语句 sql_SQL Azure不支持“入选” - 有另一种方式？

I have a very complicated table I'd like to take a temporary backup of whilst I make some changes. Normally, I'd just do the following:

SELECT *

INTO temp_User

FROM dbo.[User] AS u

Unfortunately I'm using Azure, and it appears this isn't supported:

Msg 40510, Level 16, State 1, Line 2 Statement 'SELECT INTO' is not

supported in this version of SQL Server.

Is there a way to re-create this feature into a function, potentially? I could do this by scripting the table, creating it and then inserting data using a select statement but given how frequently I use Azure, and how many databases I need to work on in this area this is very unwieldy.

解决方案

The new Azure DB Update preview has this problem resolved:

The V12 preview enables you to create a table that has no clustered

index. This feature is especially helpful for its support of the T-SQL

SELECT...INTO statement which creates a table from a query result.