@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