Sql updating multiple columns
This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.
If you are an application programmer then you will more than likely need to write TSQL code to update your SQL Server database tables.
In order to update a row in a SQL Server table you will use the UDPATE statement.
There may be times when you need to write some code to update a row, or set of rows in a table.
I did this by having a single SET clause in my UPDATE statement, with the two column name/value pairs separated with a comma.
There may be times when you don’t want to manually write a bunch of UPDATE statements with different literal strings to update your table.
In my examples above I only updated a single column with my UPDATE statement.
Suppose I wanted to change both the Toy Name and the Price columns.