- Data and Records
- Stored Procedures
- Other SQL commands
- Syntax Definitions
- SQL standads overview
- Links to software manyfacturers documentation pages
- Copyright and Warranty
Round brackets. Are used in field size definitions in logical constucts or formulas.
Alias is an alias to the original tablename, which is used instead of the tablename.
Fieldname is the name of an databasetable-field or -column in the used database table.
Fieldlist is a list of fieldnames of the used database table, separated with commas.
onum, preis, anz
Value is here a value that can be stored in the corresponding SQL data type, such as an integer, decimal number or text in "Hochkomma".
Valuelist is a list of values separated with commas (see value).
1001, 'Müller', 'Berlin', .12
Tablename is a name of an table existing or to be created in the database.
preis > 100 AND preis < 1000
( (price * prov) - .10 )
Integer ist a number without decimals.