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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-12 : 09:05:58
|
Durgesh writes "Hi
I have a problem and I feel its really diificult for me. The Company I work for has a internet application basically that application has a ASP form through which the managers across the country enter the data about their new products and any changes in the existing products basically the financial products. So the data is huge. This data regarding the changes is made in a temperory database which is called the outside database and then a person manually makes changes to the permanent database which is called the production database. I have to design a intranet application where in it gives the person who is manually updating to compare the old data from the production database and the new data in the outside database before making the changes to the production database. The field names in both the tables in the outside database and the production database are the same. I have to develop an userinterface intranet application which does the above. I wanted to know if there is a way to compare these tables in SQL SERVER. I would really appreciate if you could answer my doubt.
Thanx in advance
Durgesh" |
|
|
|
|
|
Comparing the fields in two different tables in SQL SERVER