Advanced SQL In OutSytems
Presentation on what advance sql features we can use in OutSystems.
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\quad$ : Scalar-Subqueries-Example-Code.sql
$\quad\quad$ : Correlated-Subqueries-Example-Code.sql
$\quad\quad$ : EXISTS-Example-Code.sql
$\quad\quad$ : CTEs-Example-Code.sql
$\quad\quad$ : Recursive-CTEs-Example-Code.sql
$\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