hi.. i get this code from member ragezone
Code:
USE SRO_VT_SHARD
DECLARE @CharID INT;
SET @CharID = 122
DELETE FROM _CharSkill
WHERE (CharID = @CharID)
DELETE FROM _CharSkillMastery
WHERE (CharID = @CharID)
DELETE FROM _GuildMember
WHERE (CharID = @CharID)
DELETE FROM _Inventory
WHERE (CharID = @CharID)
DELETE FROM _StaticAvatar
WHERE (CharID = @CharID)
DELETE FROM _User
WHERE (CharID = @CharID)
DELETE FROM _CharTrijob
WHERE (CharID = @CharID)
DELETE FROM _InventoryForAvatar
WHERE (CharID = @CharID)
DELETE FROM _CharQuest
WHERE (CharID = @CharID)
DELETE FROM _TimedJob
WHERE (CharID = @CharID)
DELETE FROM _Char
WHERE (CharID = @CharID)
that is single char delete.. how to group delete..
example i need delete from charId 122 to 4000
"SET @CharID = '122'to'4000'"
How? please help.