SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (NAME CHAR(1), REV INT, ID INT, PI CHAR(5),
                   CHECK (ID != 1 OR PI = 'PA001'));
INSERT INTO test VALUES ('A', 0, 1, 'PA001');
1 rows affected

INSERT INTO test VALUES ('A', 1, 1, 'PA001');
1 rows affected

INSERT INTO test VALUES ('A', 2, 1, 'PA002');
Msg 547 Level 16 State 0 Line 1
The INSERT statement conflicted with the CHECK constraint "CK__test__35BCFE0A". The conflict occurred in database "fiddle_c4abb5f9c518435fb6f88f2215747a89", table "dbo.test".
Msg 3621 Level 0 State 0 Line 1
The statement has been terminated.