Updating a select statement to update 1 800 sex dateing
Each named column is set to the value of the expression on the right-hand side of the equal sign.
Even column-name can be used in the expression—the old value is used.
If you specify a WHERE clause, Sybase IQ updates only rows satisfying the search condition.
The left side of each SET clause must be a column in a base table.
If you are not using the NUMBER(*) function, avoid using the ORDER BY clause, because the UPDATE statement performs better without it.
In an UPDATE statement, if the NUMBER(*) function is used in the SET clause and the FROM clause specifies a one-to-many join, NUMBER(*) generates unique numbers that increase, but do not increment sequentially due to row elimination.
If the update violates any check constraints, the whole statement is rolled back.
You can use the ORDER BY clause to control the result from an UPDATE when the FROM clause contains multiple joined tables.If the FROM clause specifies a one-to-many join and the SET clause references a cell from the “many” side of the join, the cell is updated from the first value selected.In other words, if the join condition causes multiple rows of the table to be updated per row ID, the first row returned becomes the update result.The IQ server may return results in any combination of lowercase and uppercase, so you cannot expect case sensitive results in a database that is case insensitive (CASE IGNORE).Further, if a single-column primary key already contains an entry Value, an INSERT of value is rejected, as it would make the primary key not unique.