update table1 set name= 'test' where ID in (1,3,5)
Update t SET Name = Case When name = 'a' then yy When Id = 'b' then zz ...... End FROM <mytable> t WHERE id IN (1,2,5,9)
Update table1 set name = 'newName1' where id = 1; Update table1 set name = 'newName3' where id = 3; Update table1 set name = 'newName7' where id = 7;
UPDATE <tablename> SET Column_Name=<new_value> WHERE ID IN(1,2,5,9) </new_value></tablename>
Update tblname Set name= case when id=1 then 'Aone' Case when iD= 4 then 'Afour' case when id= 7 then 'Aseven' End
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)