Categoria: SQL Commands

The Original Internet Language

UPDATE

Changes data in EntitySets, relationships, forms, or sets. Syntax UPDATE [ALL] [SQLsetspec] SET «field = value » [WHERE clause [EVALUATE clause] [-> clause] Parameters ALL Optional. Regardless of whether ALL is entered, all records in the set specification that meet the specified condition (if any) are updated. SQLsetspec An SQL set specification. Can contain application…
Leia mais

INSERT

Adds a single record to EntitySets or relationships ( ISQL option only). Syntax INSERT INTO object [( field)] VALUES(expr1 | NULL) [EVALUATE clause] [clause] Parameters object The name of an EntitySet or relationship with fields to which you want to add a record. A role name can be used. field A target field in object.…
Leia mais

SELECT

Lists selected data from the database. Syntax SELECT [ALL] [DISTINCT] values FROM SQLsetspec [-> setname] Parameters ALL An optional keyword indicating that all records of the specified type are to be listed. But, even if ALL is omitted, all records are processed by default. DISTINCT Specifies that only the records that contain unique values in…
Leia mais

WHERE (Condition)

WHERE States a condition. Syntax WHERE expression Parameters expression A logic expression using conditional and Boolean operators. Comments WHERE states the conditions that restrict processing in the main command to only certain members of the set specification, contingent on a value within each of the (related) records being considered. Of all the available (related) records…
Leia mais

DELETE FROM

Deletes records from EntitySets or relationships with fields. Syntax DELETE [ALL] FROM SQLsetspec [EVALUATE clause] [-> clause] Parameters ALL Optional. Whether or not you include the ALL argument, all records in SQLsetspec are deleted. SQLsetspec An SQL set specification. If omitted, records are deleted from the current set (if it exists). Comments DELETE FROM is…
Leia mais

ROLLBACK WORK

Marks the end of a transaction, discarding the results. Syntax ROLLBACK WORK Comments The ROLLBACK WORK command is the SQL equivalent of the QUITTRANSACTION command. The value of the system variable $InTransaction indicates if an explicit transaction is in progress; the ROLLBACK WORK command sets $InTransaction to 0 ($False).   See Also $InTransaction BEGIN WORK…
Leia mais

BEGIN WORK

Starts an explicit transaction. Syntax BEGIN WORK Comments This command is the SQL equivalent of the TRANSACTION command. See Also $InTransaction COMMIT WORK ROLLBACK WORK TRANSACTION

COMMIT WORK

Ends a transaction and writes all updates to the database. Syntax COMMIT WORK Comments This command is the SQL equivalent to the ENDTRANSACTION command. See Also $InTransaction BEGIN WORK ROLLBACK WORK TRANSACTION

pt_BRPortuguese