sql server - SQL: Update table where column = Multiple Values -

i created sql query updates table column column = value

code:

update products set productname = 'shoes' productid = (1,2,3,4,5,6,7,8) 

the problem productid. how can make update column id's ?

regards.

replace productid = productid in

update products  set productname = 'shoes'  productid in (1,2,3,4,5,6,7,8)