Microsoft SQL Server: Running Select Queries
Summary
This page explains how PPA outputs data from MSSQL select queries.
When you use the select action:
- The output is a list of dictionaries
- Each dictionary is a database record
- The keys of each dictionary will be the selected column names
- Each key's value will be the corresponding record field
Column Names
The column names will be taken directly from the SQL Query.
Any aliased columns containing spaces will have those spaces replaced with an underscore.
Special Functions
If the query is a special function (like SELECT @@VERSION), the column name will be missing_column_name.
Example
- Running a select query with column name aliases
- Saving the output as a variable called users
Select Action
1 2 3 4 5 6 |
|
The structure of each record in users will be:
Action Output
1 2 |
|
Datetime Columns
All datetime fields are automatically converted to date strings in the following format:
10:06:38 20/06/2020