Multiple Database Transaction
Database
2
Posts
2
Posters
0
Views
1
Watching
-
How can I use transaction on multiple database? I use SQL Server Compact Edition. Thanks...
-
How can I use transaction on multiple database? I use SQL Server Compact Edition. Thanks...
suppose you will insert some data in a table from two other's table/data base. Begin Tran Use DataBase2 insert into Table1(Name,Id,Roll,Address) select A.Name,A.Id,B.Roll,B.Address from DataBase1..Table2 A inner join DataBase2..Table3 B on A.Id = B.Id Commit tran If You use this query then you will easily transaction (Insert) data from two different data base & tables.
Mrityunjoy Bhattacharjee
modified on Sunday, August 8, 2010 12:06 PM