Updating tables in sql server
By doing this I have made sure I don’t have a bogus WHERE clause on my UPDATE statement that is going to incorrectly identify rows to be updated in my table.In my examples above I only updated a single column with my UPDATE statement.
We have already seen how to limit the rows being updated by using the WHERE clause.
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.
In my first TSQL script above, when I create the TOY table, there is typo in the first Toy Name.
I created a Toy Name of “Magic Wnd” when it should have been “Magic Wand”.