YOUR AD GOES HERE

Database command in Automation Anywhere - connection, SQL query, disconnect, insert/update/delete

Published 02, Apr 2020

My Learning Tricks


Description:
Automation anywhere Database command
AA Database Commands
automation anywhere database commands
automation anywhere database connection
automation anywhere database examples
automation anywhere database connection string
automation Anywhere in Tamil
automation anywhere database Connect
automation anywhere database Disconnect
automation anywhere database SQL Query
automation anywhere database Insert/Update/Delete
automation anywhere database Run Stored Procedure
Automation anywhere commands overview
#Database # Commands

'SQL Select Statement
SELECT * from Test WHERE Final_Status = 'Closed'

'SQL select & Count Statement
SELECT COUNT(Year1)from Test WHERE Final_Status = 'Closed’

'SQL select & ORDER BY Statement
SELECT Year1 from Test WHERE Final_Status = 'Closed' ORDER BY Date1 asc;

'SQL INSERT INTO statement
INSERT INTO Test (Year1,Final_Value) VALUES ('2016','11111');

'SQL Update Statement
UPDATE Test SET Final_Status = 'Thinash' WHERE Year1 = '2017'

Releted More Videos

  • Sorry!!! Nothing to show

You May Also Like

YOUR AD GOES HERE

YOUR AD GOES HERE