Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 82 : | Ligne 82 : | ||
:*SQLfast Tutorial - <b>7. Taking decisions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto07-Taking-decisions.pdf [full text]] | :*SQLfast Tutorial - <b>7. Taking decisions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto07-Taking-decisions.pdf [full text]] | ||
+ | ::''Chapter contents'': Alternative control statement. Displaying a message. SQLfast conditions. Skipping statements. Simple loops. | ||
+ | ::''Statements and functions'': <tt>if</tt>, <tt>if-endif</tt>, <tt>if-else-endif</tt>, <tt>showMessage</tt>, <tt>label</tt>, <tt>goto</tt>. | ||
:*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-based loops. Embedded loops. | ||
+ | ::''Statements and functions'': <tt>extract</tt>, <tt>select #n</tt>, <tt>select #[n1,n2]</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]] |
<Retour à la page d'accueil / Back>
Sommaire |