Retrieving Updated Data

[Roshawn]

Hi,

I have a Windows application that consumes a web service. The data returned
from this service contains product prices, ratings and other data, and is
saved to a local database. On occasion, some of the data from the web
service (particularly the product prices and ratings) is updated.

What I'd like to do is receive data from the web service and compare it to
the data already saved in the database. If there are any changes to the
data return from the web service, then the data in the database must change
to reflect the new web service data.

I have no idea how to get this done. Does anyone have any suggestions?

Roshawn

 

[Roshawn]

Thanks Saurabh.

However, I'm not that good with T-SQL. Are there any tutorials available
that make use of the technique you prescribed?

Roshawn

 

[Saurabh Nandu]

The best guide for T-SQL is from Microsoft I am giving the URL below
[ http://msdn.microsoft.com/library/?url=/library/en-us/tsqlref/ts_ua-uz_82n9.asp?frame=true ]


--
Regards,
Saurabh Nandu
AksTech Solutions, reflecting your needs...
[ www.AksTech.com ]
[ www.MasterCSharp.com ]