Tricky SQL Query
Posted on 2008-10-02
I'm performing a small migration in SQL Server and am wondering about how to update a common field in a set of tables.
The field that exists in about 10 tables in this database is LOCATION_ID. I want to do a global updatge that essentially says that for every LOCATION_ID field in all the tables with the word BUSINESS in the name to have the value changed from a 1 to a 2 (where the value is 1).
How would I do this?