 | 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. |
| SQL Server DateTime Information Functions
The fifty-first part of the SQL Server Programming Fundamentals tutorial is the first of two articles describing Transact-SQL functions that process date and time information. This instalment examines functions that extract elements from DateTimes. |
| SQL Server Miscellaneous String Functions
The fiftieth part of the SQL Server Programming Fundamentals tutorial completes the review of the string functions provided by Transact-SQL. This article describes six miscellaneous functions not mentioned in the previous six articles in the series. |
| SQL Server Soundex Functions
The forty-ninth part of the SQL Server Programming Fundamentals tutorial describes the Soundex functions that are provided by Transact-SQL (T-SQL). These functions allow strings to be compared according to their pronounciation by English speakers. |