|
Creates a user-defined function. ... Scalar-valued functions can be defined by using multiple Transact-SQL statements. Functions are table-valued if the RETURNS clause specifies TABLE. Depending on how the body of the function is defined, table-valued functions can be classified as inline or multi-statement functions.
|
msdn.microsoft.com/en-us/library/ms186755.aspx
|
|
|
|
SQL Aggregate Functions ... SQL scalar functions return a single value, based on the input value. ... Tip: The aggregate functions and the scalar functions will be explained in details in the next chapters.
|
www.w3schools.com/SQl/sql_functions.asp
www.w3schools.com/SQl/sql_functions.asp
|
|
|
SQL Scalar Numeric Functions ... This chapter describes the SQL Scalar Functions supported in PointBase. PointBase provides these ready to use functions to perform in-statement operations when querying or inserting data into the database.
|
www.ipd.uka.de/~oosem/mobiledb/pb/docs/server_embedded/...
www.ipd.uka.de/~oosem/mobiledb/pb/docs/server_embedded/html/htmlfiles/db_functionsFIN.html
|
|
The ANSI SQL scalar functions return a single value each time they are invoked. The SQL standard provides many scalar functions that can be used to manipulate date and time types, strings, and numbers, as well as retrieve system information such as the current user or login name.
|
www.freeweb.hu/sqlnut/sqlnut2-chp-4-sect-4.html
www.freeweb.hu/sqlnut/sqlnut2-chp-4-sect-4.html
|
|
Returns the name of the current data source. ... If exp is null, value is returned. If exp is not null, exp is returned. The possible data type or types of value must be compatible with the data type of exp. ... Returns the CONNX user name in the DBMS.
|
www.connx.com/products/connx/Connx%208.5%20UserGuide/sq...
www.connx.com/products/connx/Connx%208.5%20UserGuide/sql_scal.htm
|
|
All BBj SQL Engine custom scalar functions must be written using the Java programming language. A custom scalar function consists of a single Java class that meets the following requirements:
|
www.basis-documentation.com/b3odbc/custom_scalar_functi...
www.basis-documentation.com/b3odbc/custom_scalar_functions_bbjds.htm
|
|
The following information is a list of commonly-used scalar functions. For a complete list of SQL Server scalar functions, see the Transact SQL reference Functions help topic in the Microsoft SQL Server documentation...
|
www.ooad.org/resources/Access2003_help/html/dvconfuncti...
www.ooad.org/resources/Access2003_help/html/dvconfunctionsforexpressions.htm
|
|
Microsoft SQL Server supports all the built-in scalar functions. Oracle does not support the built-in scalar functions shown above; however, it supports USER as a synonym of CURRENT_USER and SYSDATE as a synonym of CURRENT_TIMESTAMP.
|
oreilly.com/catalog/sqlnut/chapter/ch04.html
oreilly.com/catalog/sqlnut/chapter/ch04.html
|
|
SQL Server 2000 supports three types of functions: scalar, in-line table functions, and multistatement table functions. All three types of functions accept parameters of any scalar data type except rowversion.
|
www.15seconds.com/Issue/000817.htm
|
|
