| 20. 2. Variable |
| 20. 2. 1. | Working with Variables | | |
| 20. 2. 2. | Use right function with a variable | | |
| 20. 2. 3. | Testing the ISNULL function | | |
| 20. 2. 4. | SELECT LEFT(@FullName, 5) | | |
| 20. 2. 5. | Global variable names begin with an @@ prefix. | | |
| 20. 2. 6. | XML type variable | | |
| 20. 2. 7. | Varchar type variable | | |
| 20. 2. 8. | Use if statement to check a variable | | |
| 20. 2. 9. | A variable can be assigned a value from a subquery | | |
| 20. 2. 10. | Use aggregate function with variables | | |
| 20. 2. 11. | Use Local Variables in where clause | | |
| 20. 2. 12. | A SQL script that uses variables | | |
| 20. 2. 13. | Local variables used for searches | | |
| 20. 2. 14. | Pass variable to a user-defined function | | |
| 20. 2. 15. | Use one variables in like function | | |