Beginning T-SQL: A Step-by-Step Approach

© Kathi Kellenberger, Lee Everest 2021

K. Kellenberger, L. EverestBeginning T-SQLhttps://doi.org/10.1007/978-1-4842-6606-9_4

4. Using Built-in Functions and Expressions

Kathi Kellenberger¹   and Lee Everest²

(1)

Edwardsville, IL, USA

(2)

Euless, TX, USA

 

Now that you have the knowledge to write simple SELECT statements, it is time to explore some of the other features of T-SQL that allow you to manipulate how the data is displayed, filtered, or ordered. To create expressions in T-SQL, you use functions and operators along with literal values and columns. The reasons for using expressions in T-SQL code are many. For example, you may want to display only the year of a column of the DATETIME data type on a report, or you may need to calculate a discount ...