Hi, the problem is:

My company want to migrate our SQL Server DB to Winwows Azure Server (currently we have our own domain and server), but Azure doesn't support the sentence 'Into' to create temporary tables, so we should replace all 'Into' sentences to corresponding 'Create Table' statements. Our system have up 1000 SP's with 'Into' sentences and many SP's have a lot of them.

My question: is possible generate a 'Create Table' statement automatically, from a 'select into' sentence? i want to know if Management Studio or external tool have this feature o something similar.

Sorry for my poor english but this is not my native language.

Thanks!

• Moved by Kalman Toth Saturday, February 28, 2015 2:39 PM Azure SQL Database related