Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE5 (Delphi Win64) » SQL Reference » UPDATE Statement |
UPDATE table_reference [AS correlation_name | correlation_name] [EXCLUSIVE] SET column_ref = update_value [, column_ref = update_value...] [FROM table_reference [AS correlation_name | correlation_name] [EXCLUSIVE] [[INNER | [LEFT | RIGHT] OUTER JOIN] table_reference [AS correlation_name | correlation_name] [EXCLUSIVE] ON join_condition] [WHERE predicates] [COMMIT [INTERVAL commit_interval] [FLUSH]] [NOJOINOPTIMIZE] [JOINOPTIMIZECOSTS] [NOWHEREJOINS]
SET column_ref = update_value [, column_ref = update_value...]
UPDATE orders SET ShipToContact=Customer.Contact FROM orders LEFT OUTER JOIN customer ON customer.custno=orders.custno
UPDATE orders o SET ShipToContact=c.Contact FROM orders o LEFT OUTER JOIN customer c ON c.custno=o.custno
WHERE predicates
UPDATE SalesInfo SET TaxRate=0.0825 WHERE (State='CA')
COMMIT [INTERVAL nnnn] [FLUSH]
NOJOINOPTIMIZE
JOINOPTIMIZECOSTS
NOWHEREJOINS
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |