BEGIN TRAN

SELECT @r = count(*) FROM T WITH (TABLOCKX)

if 1 = dbo.Четное(@r) 
begin
 INSERT INTO T ([поле]) VALUES (5)
end

COMMIT TRAN