You can view the SQL
code generated by a query.
SQL = Structured Query Language is a programming language used to talk to databases. With SQL, you can store, manipulate, and retrieve data from relational databases.
To view SQL code:
- At the Query Manager screen, after you've defined and run a query, click View, and then select one of the following options:
- Show SQL. EmpowerHR displays the generated SQL in a raw form, without prompting for, and performing parameter substitution.
- Show SQL with Parameters. EmpowerHR prompts you to enter parameters, and then displays the SQL with substituted parameters.
- To save the SQL script, at the SQL window, click File, and then select Write to File.
- Save the file.
© 2023 Fusion5. All rights reserved.