Summary  
This chapter demonstrates how to execute an SQL UPDATE statement from application code to modify existing database records based on a condition.

General domain of usage  
Inventory management systems

Some new stock has arrived. The store owner tells you to **set** the quantity of **all the products to 200**, which was previously **less than 100**.

Your task is to **update the quantity** of all the products to 200, which is less than 100 in terms of quantity.

This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

This module will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

Challenge: Using UPDATE