Updating multiple columns in sql
The "tiresome way" is standard SQL and how mainstream RDBMS do it. With a 100 columns, you mostly likely have a design problem...
TOT_COST 2.000 from DBRMAST T1 inner join DBRMAST t2 on t2. Would you like to answer one of these unanswered questions instead?
Note: Applications is the name of table, this table has 4 fields Application ID, Application, Owner, Responsible The New Owner is the name of the textbox that I have created for the user to enter the new Owner.
I just want to update the Owner and Responsible fields Thanks Assuming Owner is a text field you will need the single quotes.
The WHERE clause specifies which record(s) that should be updated.
The UPDATE SET commands implicitly apply on the table specified by , and it is not possible to specify the table on the SET operation.