The error message is pretty explicit:
Cannot insert the value NULL into column 'emp_num', table 'comp.task.dbo.Employee'; column does not allow nulls.
The
emp_num
column of the
Employee
table is defined as
NOT NULL
, but your INSERT operation is not providing a value.
Either provide a value (recommended) or change the table definition.