ScholarLens Back to search
2008•Apress eBooksRequires access

SQL Server Functions

Author information unavailable

Open publisher page 0 citations

Abstract

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.

About this research paper

What this paper is about

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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

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.

Key concepts: User-defined function, Data Transformation Services, Computer science, SQL/PSM, Stored procedure, Sql server, Business Intelligence Markup Language, Language Integrated Query

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
SQL Server Functions — Research Paper | ScholarLens