Code:
CREATE proc [dbo].[uspLoadArena] @serverindex char(2), @idPlayer char(7) as set nocount on Select serverindex, m_idPlayer, nArenaKills, nArenaDeaths from ArenaScore with (nolock) where serverindex = @serverindex and m_idPlayer = @idPlayer
CREATE proc [dbo].[uspSaveArena] @serverindex char(2), @idPlayer char(7), @nArenaKills int, @nArenaDeaths int as set nocount on set xact_abort on update ArenaScore set nArenaKills = @nArenaKills, nArenaDeaths = @nArenaDeaths where serverindex = @serverindex and m_idPlayer = @idPlayer
CREATE TABLE [dbo].[ArenaScore]( [serverindex] [char](2) NULL, [m_idPlayer] [char](7) NULL, [nArenaKills] [int] NULL, [nArenaDeaths] [int] NULL )