declare @Name as varchar(16) declare @CID as int Set @Name = 'Minbobo' Set @CID = 100 Update CharInfo Set Name = @Name Where CID = @CID Update TblUnifiedCharList Set BeforeCharName = @Name Where BeforeCID = @CID Update CharInfoEx Set NameChangeCount = 1 Where CID = @CID