Page 1 of 1
SQL Server
Posted: Thu May 11, 2006 11:40 am
by Jarmour
Can RoboTask update a SQL Server database? Like each night, update just the stock and price fields, but only the records that have changed, according to either a text file or an Access database?
Thanks!
SQL Server
Posted: Fri May 12, 2006 12:38 am
by Oleg
Yes, of course.
There is the "SQL Query" action for this purpose.
Use such expression as SQL query:
update MyTable set field1 = value1, field2 = value2 where field3=criteria
Also you can use variables in your query, like this:
update MyTable set field1 = {MyVar1}, field2 = {MyVar2} where field3=criteria