Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vivosomnio
Starting Member
1 Post |
 Posted - 2009-12-15 : 21:10:34
|
| Hello,I am fairly inexperienced and ill-equipped with regards to SQL queries, so let me tell you what I'm trying to accomplish.I have two SQL servers, ServerA and ServerB. Each has a database, DatabaseA and DatabaseB. Each database has a column called IPs.I would like to run a query that grabs both columns, compares them, and tells me what entries exist in DatabaseA but not DatabaseB. And then from that I could reverse it to get what entries exist in DatabaseB but not DatabaseA.I'm assuming this is feasible, but no idea how. Help would be appreciated! |
|
|
derach2000
Starting Member
37 Posts |
Posted - 2009-12-16 : 04:18:06
|
| Hi,maybe this helps...http://database.ittoolbox.com/documents/connecting-to-and-accessing-a-sql-server-database-on-another-server-18751 |
 |
|
|
|
|
|
Column Comparison...