DBI202_-_PE_-_02_-_SP_2024_-_Block_3_1893.webp

(Note: the preview image is a sample. The result of the function depends on the entered your data)
select dbo.fn_CountOfSkillsByEmpNo (1) as CountOfSkillsByEmpNo
6 of 6
Paper No: 1
CountOfSkillsByEmpNo
3
Picture 9.1
Question 10:
Write the trigger named tr_EmployeeSkill to prevent the case that the end user to input or modify invalid Employee skill information (RegDate < StartDate). For example, when we

Close
+ 100%
Zoom