How to do cross database queries and inserts using SQL in Azure
Is there a simple way to reference another database on the same server (preferably from a MERGE command)? I have two SQL databases in Azure, ‘main-sql-dev’and ‘temp-sql-dev’. I want to update the main database from the temp (transitional database). Is this doable?