Sybase SQL Remote DC38133-01-0902-01 User Manual
UPDATE statement
Function
Use this statement to modify data in the database.
Syntax 1
UPDATE table-list
SET column-name = expression, . . .
[ VERIFY ( column-name, . . . ) VALUES ( expression, . . . ) ]
[ WHERE search-condition ]
[ ORDER BY expression [ ASC | DESC ], . . . ]
SET column-name = expression, . . .
[ VERIFY ( column-name, . . . ) VALUES ( expression, . . . ) ]
[ WHERE search-condition ]
[ ORDER BY expression [ ASC | DESC ], . . . ]
Syntax 2
UPDATE table
PUBLICATION publication
{ SUBSCRIBE BY expression |
OLD SUBSCRIBE BY expression
NEW SUBSCRIBE BY expression }
WHERE search-condition
PUBLICATION publication
{ SUBSCRIBE BY expression |
OLD SUBSCRIBE BY expression
NEW SUBSCRIBE BY expression }
WHERE search-condition
expression: value | subquery
Usage
Syntax 1 and Syntax 2 are applicable only to SQL Remote.
Syntax 2 with no OLD and NEW SUBSCRIBE BY expressions must be
used in a BEFORE trigger.
used in a BEFORE trigger.
Syntax 2 with OLD and NEW SUBSCRIBE BY expressions can be used
anywhere.
anywhere.
Permissions
Must have UPDATE permission for the columns being modified.
Side effects
None.
See also
378