The auto update statistics feature of SQL Server relies on number of rows changed or updated to determine if statistics update is needed. The statistics of. I am wondering if this is possible at all. I want to update column x if a condition is true, otherwise column y would be updated UPDATE table SET CASE CONDITION. SQL UPDATE Query. The SQL UPDATE Query is used to modify the existing records in a table. Sql If Condition In Update' title='Sql If Condition In Update' />You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected. Syntax. The basic syntax of the UPDATE query with a WHERE clause is as follows. UPDATE tablename. SET column. 1 value. N value. N. WHERE condition. You can combine N number of conditions using the AND or the OR operators. Example. Consider the CUSTOMERS table having the following records. ID NAME AGE ADDRESS SALARY. Ramesh 3. 2 Ahmedabad 2. Khilan 2. 5 Delhi 1. Kota 2. 00. 0. Craig S. Mullins Database Performance Management Return to Home Page. October 2004 Using Dynamic SQL for Maximum Flexibility. Few months back I have written one article which was showing how to store image and other files into SQL Server column by converting it to byte object and receive it. SQL UPDATE Query Learn SQL Structured Programming Language in simple and easy steps starting from basic to advanced concepts with examples including database. ZQU.png' alt='Sql If Condition In Update' title='Sql If Condition In Update' />Chaitali 2. Mumbai 6. Hardik 2. Bhopal 8. Komal 2. MP 4. Muffy 2. 4 Indore 1. The following query will update the ADDRESS for a customer whose ID number is 6 in the table. SQL UPDATE CUSTOMERS. Sql If Condition In Update' title='Sql If Condition In Update' />SET ADDRESS Pune. Now, the CUSTOMERS table would have the following records. ID NAME AGE ADDRESS SALARY. Ramesh 3. 2 Ahmedabad 2. Khilan 2. 5 Delhi 1. Kota 2. 00. 0. Chaitali 2. Mumbai 6. Hardik 2. Bhopal 8. Komal 2. Pune 4. Muffy 2. 4 Indore 1. If you want to modify all the ADDRESS and the SALARY column values in the CUSTOMERS table, you do not need to use the WHERE clause as the UPDATE query would be enough as shown in the following code block. SQL UPDATE CUSTOMERS. SET ADDRESS Pune, SALARY 1. Now, CUSTOMERS table would have the following records. ID NAME AGE ADDRESS SALARY. Ramesh 3. 2 Pune 1. Call Of Duty Modern Warfare 3 Wii Download Rapidshare Premium on this page. Khilan 2. 5 Pune 1. Pune 1. 00. 0. Chaitali 2. Pune 1. Hardik 2. Pune 1. Komal 2. 2 Pune 1. Muffy 2. 4 Pune 1.