change feld value from 0 to 1 in all rows using sql 2005

• sherif.ganainy

  Valued Member

  Points: 60

  More actions

  January 23, 2014 at 10:06 pm

  #288807

  i have tabel name ( dbo.Main_Item ) and field named (Item_type)

  i need to change all values from 1 to 0

• Mitesh Oswal

  SSCrazy

  Points: 2798

  More actions

  January 23, 2014 at 10:09 pm

  #1683000

  Update dbo.Main_Item

  SET Item_type = 0

  where Item_type = 1

  Regards,
  Mitesh OSwal
  +918698619998

• sherif.ganainy

  Valued Member

  Points: 60

  More actions

  January 23, 2014 at 10:17 pm

  #1683002

  when make Execute this message appear

  Msg 208, Level 16, State 1, Line 1

  Invalid object name 'dbo.Main_Item'.

• sherif.ganainy

  Valued Member

  Points: 60

  More actions

  January 23, 2014 at 10:33 pm

  #1683005

  working OK .... Thank you