| 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 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 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 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 pronunciation by English speakers. |
| SQL Server Single Character Functions The forty-eighth part of the SQL Server Programming Fundamentals tutorial looks at single character string processing functions. This article describes four functions that allow the conversion between characters and ASCII or Unicode values. |
| SQL Server Case Conversion Functions The forty-sixth part of the SQL Server Programming Fundamentals tutorial continues the discussion of Transact-SQL (T-SQL) string processing functions. This article describes two functions that allow text to be converted to upper or lower case. |
| SQL Server Trimming Functions The forty-seventh part of the SQL Server Programming Fundamentals tutorial continues the investigation of Transact-SQL (T-SQL) string processing functions. This article describes two functions that remove leading and trailing white space from strings. |
| SQL Server String Index Functions The forty-fifth part of the SQL Server Programming Fundamentals tutorial continues the discussion of Transact-SQL (T-SQL) string processing functions. This instalment considers functions that read or modify character data at a specific index position. |