update table sql multiple set

Solutions on MaxInterview for update table sql multiple set by the best coders in the world

Search
showing results for - "update table sql multiple set"
Ainsleigh
26 Aug 2019
1-- CANT do multiple sets but can do case
2UPDATE table
3SET ID = CASE WHEN ID = 2555 THEN 111111259 
4              WHEN ID = 2724 THEN 111111261
5              WHEN ID = 2021 THEN 111111263
6              WHEN ID = 2017 THEN 111111264
7         END
8WHERE ID IN (2555,2724,2021,2017)
9
source
similar questions
mysql update one table from another table multiple columnssql update multiple tablessql update from two different databasehow to update the multiple rows in sqlset sql multiple valuessql oracle update multiple rowssql select merge multiple valuessql server insert multiple rowsupdate query for multiple columnssql update multiple columns from another tableinsert multiple values into one column sqlupdate multiple columns in sqlmultiple replace value mssqlsql query multiple tablessql query update multiple columnsput multiple value in a like sqlselect query in sql for multiple valuesadd multiple field in table sqlsql server update multiple columns at onceadd multiple columns to table sqlsql insert multiple rows from selectsql run multiple updates in one query
queries leading to this page
sql server update multiple rows with different valuessql update for multiple rowsupdate query in sql set single value in multiple where conditionsql update multiple rows with different valuesupdate multiple columns sqlupdate multiple rows sql serversql update multiple rowsupdate multiple rows with different values sqlupdate multiple records sqlhow to update multiple tables in single query in sql serverupdate multiple rows sql where selectmultiple update with 1 queryupdate multiple rows in sqlupdate sql set multiple valuessql update table with multiple valuesupdate query with multiple set conditionsmultiple update statements on a tablesqlsrv multiple updates in single sql statementupdate query in sql set multiple valueshow to multiple update in sqlupdate table sql multiple set