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

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

SQL Server Ranking Functions
The thirty-first part of the SQL Server Programming Fundamentals tutorial describes the use of ranking functions within SQL queries. These functions add a new column to the results of a query, applying a ranking value to every row that is returned.

SQL Server Arithmetic Operators
The thirty-second part of the SQL Server Programming Fundamentals tutorial describes the basic arithmetic operators provided by Transact-SQL (T-SQL). These operators allow simple mathematical operations within queries, procedures and other statements.

SQL Server String Concatenation Operator
The thirty-third part of the SQL Server Programming Fundamentals tutorial describes the the string concatenation operator. This operator allows two strings to be combined. The operator can be used with literals, variables and columns in queries.

SQL Server Comparison Operators
The thirty-fourth part of the SQL Server Programming Fundamentals tutorial examines the comparison operators. These allow the creation of Boolean expressions that determine if two values are equal or, if not, which is the larger or smaller.

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.

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.

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

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

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