Declare @Map int

Select @Map=MapNumber from Character Where AccountID = @uid

if (@Map=30)

begin

    UPDATE [MEMB_STAT] Set ConnectStat=0 where memb___id=@uid

end

else

if (@Map=31)

UPDATE [Character] SET MapNumber = 0, MapPosX = 130, MapPosY = 130 WHERE (MapNumber = 30) AND

SET NOCOUNT OFF

End

GO