1:---数据库修改更新
update 表名 set 列名=Replace(列名,'需要替换的东西','要替换进来的东西')
2:---创建临时表
select a.UId,a.ULoginName,c.* into #UserRole from
(select * from dt_Users) a left join
(select * from Relation_UserRole) b on a.UId=b.UId left join
(select * from [Role]) c on b.RoleId=c.RoleId