From the course: Querying Microsoft SQL Server 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use functions in T-SQL

Use functions in T-SQL - SQL Server Tutorial

From the course: Querying Microsoft SQL Server 2019

Start my 1-month free trial

Use functions in T-SQL

“

- [Instructor] SQL server ships with a large number of built-in functions that you can leverage to manipulate the data that's stored in your database tables. In this chapter, I'm going to introduce you to some of my favorites, but I thought it'd be helpful to get an overview first. The built-in functions fall into a number of categories. We've already talked about the aggregate functions that are typically paired with the GROUP BY clause. These'll help you find the sum total, or count, or average of a number of values. String functions manipulate text strings by extracting and replacing characters, or joining text together. Mathematical functions can be useful for rounding values, finding logarithms and exponents, or working with geometry, such as calculating sine, cosine, and tangents. There are also mathematical functions for converting between radians and degrees, or accurately referencing the constant value of pi for…

Contents