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.
KeywordsRanking Function Server Function Aggregate Function Identity Column Current Session
Unable to display preview. Download preview PDF.