Sign In
Create your first automation in just a few minutes.Try Studio Web →
Xebia - SQL Query Builder
by YouTube
0
Activity
<100
Summary
Summary
SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable
Overview
Overview
It’s recommended that we have a Dictionary set up for the key to act as column and value of dictionary as value match in Database.
Example:
Dt.Select([Column1]='value1' AND [column2]='value2')
The bolded text can be obtained in either AND or OR format as per requirement using the component which is obtained in String format(Data Type).
I/P: Dictionary values
O/P: SQL Query as String
Features
Features
Saves time in creating SQL query from scratch and can be used for dynamic SQL commands as well.
Additional Information
Additional Information
Dependencies
None
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
MIT
Privacy Terms
Technical
Version
2020.4.1Updated
July 9, 2020Works with
Compatible across all UiPath codes above 11.0
Certification
Silver Certified
Tags
Support
UiPath Community Support
Resources
Similar Listings
