sql on update code example

Example 1: sql update query

--update query example
 UPDATE table_name
 SET column1 = value1, column2 = value2, ...
 WHERE condition;

Example 2: mssql update

UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;

Example 3: update sql

-- sql update using string format 
String = "UPDATE yourtable SET yourcolumn = '" + yourvealueintext + "' WHERE column = " + item_to_compare_the_position_of_Your_Column;
                                           -- or                                            
String = "UPDATE yourtable SET yourcolumn = " + yourvalue_in_number + " WHERE column = " + item_to_compare_the_position_of_Your_Column;

Example 4: update sql

UPDATE table_name

 SET column1 = value1, column2 = value2, ...

 WHERE condition;