哪位大侠指导下，SQL Server中，替换所有表中，某个字符串的语句怎么写啊

Question

如有50张表，表中若干张表都有字段department，把所有department中所有，”运输部”改成“运维部”

Answer 1

 update 表 set department = '运维部' where department = '运输部'

50个表的话，先遍历表
select name from sysobjects where xtype = "U"
然后循环