Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 11. Restructuring the Appearance of Data
Q&A
Q1:
Are all the functions in the ANSI standard?
A1:
No, not all functions are exactly ANSI SQL. Functions, like data types, are often implementation-dependent. Most implementations contain supersets of the ANSI functions; many have a wide range of functions with extended capability, whereas other implementations seem to be somewhat limited. Several examples of functions from selected implementations are included. However, because so many implementations use similar functions (although they may slightly differ ), check your particular implementation for available functions and their usage.
Q2:
Is the data actually changed in the database when using functions?
A2:
No. Data is not changed in the database when using functions. Functions are typically used in queries to manipulate the output's appearance.