update table sql multiple set
-- CANT do multiple sets but can do case
UPDATE table
SET ID = CASE WHEN ID = 2555 THEN 111111259
WHEN ID = 2724 THEN 111111261
WHEN ID = 2021 THEN 111111263
WHEN ID = 2017 THEN 111111264
END
WHERE ID IN (2555,2724,2021,2017)
Are there any code examples left?
New code examples in category SQL
Relative searches
sqlsrv multiple updates in single sql statement
sql update table with multiple values
sql update multiple rows with different values
sql server update multiple rows with different values
update sql set multiple values
multiple update statements on a table
update multiple rows sql server
sql update multiple rows
update multiple rows with different values sql
how to update multiple tables in single query in sql server
update query in sql set single value in multiple where condition
update query in sql set multiple values
update multiple columns sql
update multiple records sql
