Updating multiple columns dating coach in new york
If you omit the WHERE clause, all records in the table will be updated!
The WHERE clause specifies which record(s) that should be updated.
I suspect OP just used an alias loosely because the question isn't about correctness of syntax, but "why" this syntax.
design problem in general terms but there are circumstances where bulk validation / data cleaning may be required.
I am currently engaged in so doing and in SQL Server 2012 you can now update more than 1 column per @John Woo answer below.
If you're doing it manually, use SQL Management Studio's editor and enter the data directly into the row rather than writing a query.
The "tiresome way" is standard SQL and how mainstream RDBMS do it.
Third, the WHERE clause specifies the rows that you want to update.