BEGIN
  DECLARE @c INT
  SELECT @c = count(*)
    FROM foo
    WHERE bar = @a_param

  IF @c < 10 THEN
    INSERT INTO foo
      (bar)
    VALUES (@a_param)
  END IF
END

SELECT @c = count(*) WITH (TABLOCKX, HOLDLOCK)