QRY: Update Product IsSold

Created by Kevin Schmidt - HCPro, Modified on Thu, 9 Oct at 3:11 AM by Kevin Schmidt - HCPro

select *

from aptify.dbo.Product

where ID = 66744


update aptify.dbo.Product

set IsSold = 1               --1 = checked 0 = unchecked--

where ID in (66744,65846)             --ProductID for multiple product IDs you can update multiple by separating the IDs with a comma--





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article