HOUR 9. Getting to Know the T-SQL Functions

The T-SQL language contains numerous functions that you can incorporate into the T-SQL statements that you build. These functions perform a variety of important tasks. In this hour you’ll cover some of the commonly used numeric, string, date/time, and null-related functions. For additional information on the plethora of T-SQL functions available, consult Books Online (online help for SQL Server). In this hour you’ll learn:

How to work with some of the numeric functions available in T-SQL

How to work with some of the string functions available in T-SQL

How to work with some of the date/time functions available in T-SQL

How to use T-SQL to work with nulls

By the Way

The examples that follow ...

Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.