Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 86 : | Ligne 86 : | ||
:*SQLfast Tutorial - <b>8. Reading data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto08-Reading-data.pdf [full text]] | :*SQLfast Tutorial - <b>8. Reading data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto08-Reading-data.pdf [full text]] | ||
− | ::''Chapter contents'': Extracting data from the database. Indexed <tt>select</tt> queries. Queries which return no rows. Coping with empty sets and null values. SQL | + | ::''Chapter contents'': Extracting data from the database. Indexed <tt>select</tt> queries. Queries which return no rows. Coping with empty sets and null values. SQL for loop. Embedded loops. |
− | ::''Statements and functions'': <tt>extract</tt>, <tt>select #n</tt>, <tt>select #[n1,n2]</tt>, <tt>SQLdiag</tt>. | + | ::''Statements and functions'': <tt>extract</tt>, <tt>select #n</tt>, <tt>select #[n1,n2]</tt>, <tt>for-endfor</tt>, <tt>SQLdiag</tt>. |
:*SQLfast Tutorial - <b>9. Looping - The final chapter</b>, draft version, March 11, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto09-More-on-Loops.pdf [full text]] | :*SQLfast Tutorial - <b>9. Looping - The final chapter</b>, draft version, March 11, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto09-More-on-Loops.pdf [full text]] | ||
+ | ::''Chapter contents'': SQL-based for loop. Range loops. While loop. Controlling a loop. Loops internals. | ||
+ | ::''Statements and functions'': <tt>for-endfor</tt>, <tt>while-endwhile</tt>, <tt>next</tt>, <tt>exit</tt>. | ||
:*SQLfast Tutorial - <b>10. SQLfast expressions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto10-Expressions.pdf [full text]] | :*SQLfast Tutorial - <b>10. SQLfast expressions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto10-Expressions.pdf [full text]] | ||
+ | ::''Chapter contents'': Syntax of SQLfast expressions. Numeric expressions. Character string expressions. Logical expressions. Time expressions. General functions. Using external libraries. | ||
+ | ::''Statements and functions'': <tt>compute</tt>, <tt>if</tt>, <tt>while</tt>, <tt>execApp</tt>, <tt>function</tt>. | ||
:*SQLfast Tutorial - <b>11. Output channels</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto11-Output-Channels.pdf [full text]] | :*SQLfast Tutorial - <b>11. Output channels</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto11-Output-Channels.pdf [full text]] |
<Retour à la page d'accueil / Back>
Sommaire |