I am new in sql.
I have this table and I have created some constrains in the table:

```
Create Table Instructor(

InstructorID Integer NOT NULL Identity(0,1),
FirstName Varchar(30) NOT NULL,
LastName Varchar(40) NOT NULL,
DateOfBirth DATE NOT NULL,
InstructorAddress Varchar(256) NOT NULL,
PhoneNumber Varchar(40) NULL,
JobTitle Varchar(40) NOT NULL,
PayGrade Float NOT NULL,
ChargingFee Float NULL,

CONSTRAINT InstructorPK PRIMARY KEY(InstructorID),
CONSTRAINT ValidBirthYearInstructor CHECK( (DATEDIFF(year, DateOfBirth, getdate())>18) 
or (DATEDIFF(year, DateOfBirth, getdate())=18 and DATEDIFF(month, DateOfBirth, getdate())>0) 
or (DATEDIFF(year, DateOfBirth, getdate())=18 AND DATEDIFF(month, DateOfBirth, getdate())=0) AND DATEDIFF(day, DateOfBirth, getdate())=0)

);

```

This is the insert query:

```
INSERT INTO Instructor (FirstName, LastName, DateOfBirth, InstructorAddress, PhoneNumber, JobTitle, PayGrade, ChargingFee)
VALUES 
    ('Marcus','Jhon','2000-06-12','Std. Scuba Tank, Yellow','+407771231241','Fitness instructor',301.40,30.2),
    ('Marcus','Jhon','2000-06-12','Std. Scuba Tank, Yellow','+407771231241','Fitness instructor',301.40,30.2),
    ('Marcus','Jhon','2000-06-12','Std. Scuba Tank, Yellow','+407771231241','Fitness instructor',301.40,30.2);

```

and if I will put a DateOfBirth that is under 18 years old it will give me this error:
The INSERT statement conflicted with the CHECK constraint "ValidBirthYearInstructor". The conflict occurred in database "HEALTH CLUB Database", table "dbo.Instructor", column 'DateOfBirth'.
I understand that the error is coming form the fact that I insert a person under 18 years old, but it will give me this error for all and it will insert nothing.

What can I do to be able to have an error and to have all the other rows inserted?