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
SQL Server
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
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