 | SQL Server Triggers
The sixtieth and final part of the SQL Server Programming Fundamentals tutorial considers the use of triggers. SQL Server triggers can be defined against tables and views to intercept insert, update and delete statements and modify their results. |
| SQL Server User-Defined Functions
The fifty-ninth part of the SQL Server Programming Fundamentals tutorial examines the creation of user-defined functions. These are custom functions that can be used within scripts and procedures in the same manner as standard functions. |
| SQL Server Table Variables
The fifty-eighth part of the SQL Server Programming Fundamentals tutorial describes table variables. These special variables differ from those that hold single values by allowing a table structure to be temporarily declared and populated with information. |
| SQL Server Temporary Tables
The fifty-seventh part of the SQL Server Programming Fundamentals tutorial investigates temporary tables. Temporary tables can be used to hold information during long-running or complex operations without locking live data rows. |
| SQL Server Cursors
The fifty-sixth part of the SQL Server Programming Fundamentals tutorial examines the use of cursors in Transact-SQL (T-SQL). Cursors are database objects that allow a data set that has been generated using a query to be processed a single row at a time. |
| Transact-SQL Delayed Execution
Transact-SQL includes the WAITFOR statement. This command allows the execution of a script or procedure to be blocked for a period of up to twenty-four hours. The process can be delayed until a specified time or for a number of hours, minutes and seconds. |
| SQL Server WHILE Loops
The fifty-fifth part of the SQL Server Programming Fundamentals tutorial examines Transact-SQL's (T-SQL) WHILE statement. This powerful flow-of-control command allows the creation of looping structures in scripts and stored procedures. |
| SQL Server IF Conditions
The fifty-fourth part of the SQL Server Programming Fundamentals tutorial investigates the use of IF...ELSE statements. These are flow-of-control commands that can be used to conditionally execute one or more Transact-SQL (T-SQL) statements. |
| SQL Server CASE Expressions
The fifty-third part of the SQL Server Programming Fundamentals tutorial examines one of the conditional statements available to the Transact-SQL (T-SQL) developer. CASE expressions allow a value to be determined based upon a number of conditions. |
| SQL Server DateTime Manipulation Functions
The fifty-second part of the SQL Server Programming Fundamentals tutorial is the second of two articles examining Transact-SQL functions that process DateTime information. This instalment describes two functions that manipulate dates and times. |
|
|