QA

Team-Fly    

 
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.


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net