O'Reilly logo

Microsoft SQL Server 2005, Compact Edition by Trent Swanson, Prashant Dhingra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Using the Built-In Functions

IN THIS CHAPTER

SQL Server Compact Edition supports built-in functions for counting, calculations, strings, and date manipulations. These functions are a subset function that SQL Server 2005 supports. The best way to learn the SQL Server Compact Edition built-in functions is to run the functions yourself and see the results.

Mathematical Functions

Use the mathematical functions to operate numerical expressions. Mathematical functions operate on a numerical category data type. You can input float, real, integer, smallint, tinyint, and money.

ABS (Absolute)

The ABS (Absolute) mathematical function takes a numeric ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required