Loop through databases on server, and update data

Question

I have a server with multiple databases. I need to loop through these databases and change a value in one record, in one table, in each database. How can this be done?

Answer 1

EXEC sp_MSForEachDB ' Use ?; UPDATE ?.dbo.MyTable SET MyValue=999  '