@username=＇zhuxiyan991w＇
这个是要修改的ID

@username1=＇zhuxiya1w＇

这个是修改后的帐号

大家复制下面的脚本 替换修改的ID就可以了，到sql查询分析器里面运行

；；；；；；；；；

DECLARE @username varchar(15),@username1 varchar(15)
set @username=＇zhuxiyan991w＇
set @username1=＇zhuxiya1w＇

UPDATE [rxjhACCOUNT].[dbo].[TBL_ACCOUNT]
SET [FLD_ID] = @username1
WHERE [FLD_ID] like @username

UPDATE [rxjhgame].[dbo].[TBL_PublicWarehouse]
SET [FLD_ID] = @username1
WHERE [FLD_ID] like @username

UPDATE [rxjhgame].[dbo].[TBL_Warehouse]
SET [FLD_ID] = @username1
WHERE [FLD_ID] like @username

UPDATE [rxjhgame].[dbo].[TBL_CHAR]
SET [FLD_ID] = @username1
WHERE [FLD_ID] like @username