SQL Server

Discuss RoboTask here
Post Reply
Jarmour
Posts: 1
Joined: Thu May 11, 2006 11:33 am

SQL Server

Post 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!
Oleg
Site Admin
Posts: 3202
Joined: Thu Jan 01, 1970 1:00 am
Contact:

SQL Server

Post 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
Post Reply