The UPDATE statement updates the values of specified rows and columns in a table in an external database.
UPDATE Database.StockPrices AS SP SET PRICE = Body.Message.StockPrice WHERE SP.COMPANY =Body.Message.Company
UPDATE Database.INVENTORY AS INV SET QUANTITY = INV.QUANTITY - Body.Message.QuantitySold WHERE INV.ITEMNUMBER = Body.Message.ItemNumber
UPDATE Database.table AS T SET column1 = T.column1+1, column2 = T.column2+1;
The column on the left of the assignment must be a single identifier. It must not be qualified with a table name or correlation name. In contrast, any column references to the right of the assignment must be qualified with a table name or correlation name.
SET field = expression;
For information about handling database errors, see Capturing database state.
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ak05160_ |