Give us feedback

Forge

Forge is a repository of reusable, open code modules, connectors, UI components, and business solutions to help speed up your OutSystems apps delivery time.
Not finding the asset you need? 
6644
Available
assets
+84
In the last
30 days 
646
Downloads in
the last 7 days
result for tag 
"WITH (NOLOCK)"
sql-advanced-query-samples-for-dummies
Web icon
SQL Advanced Query Samples for Dummies
by 
Galter
The purpose of this application is to present practical examples of using advanced SQL commands for your daily life, such as: SQL Tips (WITH NOLOCK or READUNCOMMITTED), Recursion using CTEs, temporary tables at session and global level, Pivot Table, Unpivot Table, APPLY commands (CROSS APPLY and OUTER APPLY), SPLIT_SQL() and spatial data (geometry and geography).
Demonstration of the use of the EncodeSql () function to guarantee the security of the operation in question, as well as a practical example of Dynamic Sorting in Advanced Query.
Latest version
2.0.0
Latest release
3 Oct 2021
Compatible with
OutSystems 11
APPLY COMMANDS
Common Table Express
CROSS A
CTEs
OUTER APPLY
pivot table
Spatial Data
SPLIT SQL FUNCTION
STRING_SPLIT()
TEMPORARY TABLES
Unpivot table
WITH (NOLOCK)