Re: Regularly update table
From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 05/20/04
- Next message: Miroo_news: "Re: Table alias does not exist but works"
- Previous message: ATHENS 2004: "74077 - Please Help"
- In reply to: Malik: "Regularly update table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 May 2004 13:47:11 +0530
There isn't something inbuilt to achieve the same functionality. But there
are always workarounds for the same.
1. You can write a windows service that will ping the internet for the
current values and then update the respective tables.
2. You can write a job / windows scheduler that will query at specified
interval of time and then update the tables.
Or you can use any offline mechanisms for the same.
-- HTH, Vinod Kumar MCSE, DBA, MCAD, MCSD http://www.extremeexperts.com Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp "Malik" <anonymous@discussions.microsoft.com> wrote in message news:E8FDD0B4-4005-416E-864E-BB3279BFF565@microsoft.com... > I have a currency Rate table which contains different currencies rates with respect to us $. > is there any way to get currency rates from internet and automatically update table. > thanx
- Next message: Miroo_news: "Re: Table alias does not exist but works"
- Previous message: ATHENS 2004: "74077 - Please Help"
- In reply to: Malik: "Regularly update table"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
