| SQL Server Substring Functions The forty-fourth part of the SQL Server Programming Fundamentals tutorial begins a look at the string processing functions provided by Transact-SQL (T-SQL). This article describes three functions that allow you to extract substrings from character types. |
| SQL Server Random Number Generation The forty-third part of the SQL Server Programming Fundamentals tutorial completes the examination of Transact-SQL's (T-SQL) mathematical functions. This article describes the Rand function, which allows the generation of pseudo-random numbers. |
| SQL Server Logarithmic Functions The forty-second part of the SQL Server Programming Fundamentals tutorial continues the examination of the mathematical Transact-SQL (T-SQL) functions. This article considers the logarithmic functions that are provided by Transact-SQL. |
| SQL Server Trigonometric Functions The forty-first part of the SQL Server Programming Fundamentals tutorial continues the examination of Transact-SQL (T-SQL) mathematical functions. This article considers the trigonometric functions that allow SQL Server to work with angular data. |
| SQL Server Rounding Functions The fortieth part of the SQL Server Programming Fundamentals tutorial continues the discussion of mathematical functions provided by Transact-SQL (T-SQL). This article describes three functions that can be used to round floating and fixed-point numbers. |
| SQL Server Basic Mathematical Functions The thirty-ninth part of the SQL Server Programming Fundamentals tutorial begins an examination of mathematical functions provided by Transact-SQL (T-SQL). This article describes five basic functions. Future articles will look at more advanced functions. |
| SQL Server Cast and Convert Functions The thirty-eighth part of the SQL Server Programming Fundamentals tutorial discusses the cast and convert functions provided by Transact-SQL (T-SQL). These two standard functions allow values to be explicitly converted from one data type to another. |
| Transact-SQL Operator Precedence The thirty-seventh part of the SQL Server Programming Fundamentals tutorial brings together information from the previous articles. This article is a simple reference for the precedence of the Transact-SQL (T-SQL) operators. |
| SQL Server All, Some and Any Operators The thirty-sixth part of the SQL Server Programming Fundamentals tutorial completes the review of the Transact-SQL (T-SQL) set of operators. This article describes the ALL, SOME and ANY operators, which are used to compare scalar values with column data. |
| SQL Server Logical Bitwise Operators The thirty-fifth part of the SQL Server Programming Fundamentals tutorial investigates the logical bitwise operators. These operators perform operations upon the individual binary digits that are held within numeric or binary data types. |