SO I have 2 different databases that have same tables and fields. I need to compare one table and run query to find all rows that are in one database but not in the other. First I want to run a query that just shows me a report. Once I view the report and confirm what is missing I then want to run a query that will actually update the 2nd database with the rows that are missing. I am running SQL Server 2000
You have gone quite well on this. Just a small change and it will work perfectly:
SerialNo = s.SerialNo+2000000
from [192.168.35.100].vrp.dbo.rptrp s, rptrp h
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days.
Lets' understand the Au…