This web site uses cookies. By using the site you accept the cookie policy.This message is for compliance with the UK ICO law.

<< Previous | 1 | 2 | 3 | 4 | 5 | 6 | Next >> |
 SQL Server Ranking FunctionsThe 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 OperatorsThe 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 OperatorThe 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 OperatorsThe 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 OperatorsThe 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 OperatorsThe 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 PrecedenceThe 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 FunctionsThe 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 FunctionsThe 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 FunctionsThe 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 >> |