Click here to Skip to main content
15,877,967 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
While performing cross database query is common in SQL server, But the same is not supported in Azuer SQL. Though i can query and join table across multiple databases using External Table but it doesn't support DML operations. So Can you Suggest me any way to do DML operation across databases.

What I have tried:

I have tried using external tables but this only works for Querying and joins.
Updated 1-Jun-20 19:16pm

1 solution

Have you already tried using a linked server? See: Create Linked Servers - SQL Server | Microsoft Docs[^]
Share this answer
[no name] 6-Jun-20 0:35am    
Thanks @Wendelius.
Wendelius 12-Jun-20 16:32pm    
You're welcome!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900