January 23, 2014 at 10:06 pm
i have tabel name ( dbo.Main_Item ) and field named (Item_type)
i need to change all values from 1 to 0
January 23, 2014 at 10:09 pm
Update dbo.Main_Item
SET Item_type = 0
where Item_type = 1
Regards,
Mitesh OSwal
+918698619998
January 23, 2014 at 10:17 pm
when make Execute this message appear
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.Main_Item'.
January 23, 2014 at 10:33 pm
working OK .... Thank you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy