create proc dbo.GetTest(
    @pName varchar(50) = '',
    @pID   int = 0 out
)
as
set nocount on
begin
    select @pID = TestID from TestIds where TestName = @pName
    if ( @@rowcount = 0 )
    begin
        select @pID = isnull(max(TestID),0) + 1 from TestIDs
        insert TestIDs
        select TestID = @pID, TestName = @pName
    end
end