You administer a Windows Azure SQL Database database named Orders. You need to create a copy of Orders named Orders_Reporting. Which Transact-SQL command should you use?
A. Option A
B. Option B
C. Option C
D. Option D
2 Comments on “Which Transact-SQL command should you use?”
etsays:
‘AS COPY OF’ is in SQL 2014(Azure) not available in SQL 2012
0
0
jxsays:
Thanks for that bit of info. The question did mention that the admin is working on an AZURE SQL Database and NOT 2012. So A would still be correct.
‘AS COPY OF’ is in SQL 2014(Azure) not available in SQL 2012
0
0
Thanks for that bit of info. The question did mention that the admin is working on an AZURE SQL Database and NOT 2012. So A would still be correct.
1
0