SQL Server Programming Fundamentals (5) :: BlackWasp Software Development

<< Previous | 1 | 2 | 3 | 4 | 5 | 6 | Next >> |

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 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 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 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 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.

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 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 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.

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.

<< Previous | 1 | 2 | 3 | 4 | 5 | 6 | Next >> |