Advanced SQL In OutSytems

Presentation on what advance sql features we can use in OutSystems.

SQLApp OutSystems Demo

https://personal-u1aragiz.outsystemscloud.com/SQLApp/Entry1.aspx?_ts=638598438759656814

AdventureWorks sample databases

https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms\

AdventureWorks2019.bak

Example of Advance SQL in OutSystems

$\quad$ ISULL, COALESCE and NULLIF

$\quad\quad$ : ISNULL+COALESCE.sql

$\quad\quad$ : NULLIF.sql

$\quad$ Flattens the data

$\quad\quad$ : STUFF.sql

$\quad\quad$ : FOR-XML-PATH-With-STUFF-Example-Code.sql

$\quad\quad$ : STRING_AGG.sql

$\quad\quad$ : PIVOT-Part-1-Example-Code.sql

$\quad\quad$ : PIVOT-Part-2-Example-Code.sql

$\quad$ Subqueries

$\quad\quad$ : Scalar-Subqueries-Example-Code.sql

$\quad\quad$ : Correlated-Subqueries-Example-Code.sql

$\quad\quad$ : EXISTS-Example-Code.sql

$\quad$ CTEs

$\quad\quad$ : CTEs-Example-Code.sql

$\quad\quad$ : Recursive-CTEs-Example-Code.sql

$\quad$ Temp Tables

$\quad\quad$ : CREATE-and-INSERT-Example-Code.sql

$\quad\quad$ : DELETE-Example-Code.sql

$\quad\quad$ : Temp-Tables-Example-Code.sql

$\quad\quad$ : TRUNCATE-Example-Code.sql

$\quad\quad$ : Update-Example-Code.sql