Transaction In Sql Server

Posted by Alok under Interview Questions on 12/18/2011 | Points: 10 | Views : 1833 | Status : [Member] | Replies : 3
How Can We Perform Transaction Between Two Table of Two Different Databases...

Thanks & Regards,
Alokssm



Responses

Posted by: Vuyiswamb on: 12/18/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
Yes you can do that

SELECT * FROM    DATABASE1.DBO.TABLE1 DB1 

INNER JOIN DATABASE2.DBO.TABLE2 DB2
ON DB1.MATCHFIELD = DB2.MATCHFIELD


Thank you for posting at Dotnetfunda
[Administrator]

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sksamantaray on: 12/19/2011 [Member] Silver | Points: 25

Up
0
Down
Go ahead with Answer of Mr.Vuyiswamb provided the databases are in same machine

Thanks,
Sanjay

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arefin on: 12/19/2011 [Member] Starter | Points: 25

Up
0
Down
You can see the link:
http://forums.asp.net/t/1096615.aspx/1

Thanks,
Arefin

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response