SQL Server Functions


In this chapter, I’ll demonstrate how to use SQL Server built-in functions in your Transact-SQL code. SQL Server built-in functions, not to be confused with the user-defined functions covered in Chapter 11, allow you to performaggregations,mathematical operations, stringmanipulation, row ranking, andmuchmore. SQL Server 2008 has added new functions as well, including GROUPING, SYSDATETIME, SYSDATETIMEOFFSET, SYSUTCDATETIME, SWITCHOFFSET, and TODATETIMEOFFSET—all of which I’ll demonstrate. I’ll also cover the new SQL Server 2008 improvement that allows you to return binary data in a string hexadecimal literal format.


Ranking Function Server Function Aggregate Function Identity Column Current Session 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Joseph Sack 2008

Personalised recommendations