| || |
Can we fire sql on two different connections
I need to vaildate two tables which are exactly same in structure but stored in two different forms.
One is in sqlserver 2008 and other is in excel.
I am able to get two different RecordSets by having two different connections i.e. one for excel and one for sqlnativeclient.
Now I want to comapre so I was thinking of firing a query like
(Select * from one) Union (Select * from two)
(SELECT * FROM one) INTERSECTION (SELECT * FROM two)
Is it possible to fire a single query on different databases with different connections.
Thanks in advance.... [img]/images/graemlins/smile.gif[/img]
Re: Can we fire sql on two different connections
Creating DataBase link between databases will allow you to join tables between databases and they should be of same type. But in your case it's excel v/s database, so I don't think it's possible.