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 ...

Get Microsoft SQL Server 2005, Compact Edition 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.