1. Basic BEFORE INSERT Trigger
2. Basic AFTER INSERT Trigger
3. BEFORE UPDATE Trigger for Salary Increase
4. AFTER UPDATE Trigger for Salary Log
5. BEFORE DELETE Trigger
6. AFTER DELETE Trigger
7. Trigger to Prevent Insert if Employee Already Exists
8. Trigger to Set Default Values on Insert
9. BEFORE UPDATE Trigger to Prevent Update of Primary Key
10. Trigger for Auditing Table Changes
11. Trigger to Auto-Increment ID on Insert
12. Trigger to Log Changes in Job Title
13. Trigger to Deny Weekend Inserts
14. Trigger to Update Managers Report Count
15. Trigger to Calculate Age on Insert
16. Trigger to Prevent Future Hire Dates
17. Trigger to Default Commission to Zero
18. Trigger to Log Updates to Employee Contact Information
19. Trigger to Prevent Deletion of Critical Data
20. Trigger to Auto-Fill Full Name on Insert
21. Trigger to Ensure Minimum Salary
22. Trigger to Log Promotions
23. Trigger to Calculate Service Duration on Update
24. Trigger to Audit Salary Changes
25. Trigger to Restrict Updates During Business Hours
26. Trigger to Log Employee Termination
27. Trigger to Prevent Deletion of Active Employees
28. Trigger to Enforce Unique Email
29. Trigger to Prevent Insert During Maintenance Window
30. Trigger to Log Manager Changes
31. Trigger to Enforce Maximum Number of Reports
32. Trigger to Automatically Set Employee Status
33. Trigger to Deny Update of Critical Fields
34. Trigger to Prevent Negative Salary
35. Trigger to Set Default Hire Date
36. Trigger to Log Email Address Changes
37. Trigger to Restrict Deletion of Employees with Reports
38. Trigger to Auto-Assign Manager
39. Trigger to Log Department Changes
40. Trigger to Deny Deletion of Recent Hires
41. Trigger to Restrict Salary Increase to Specific Percentage
42. Trigger to Prevent Updates to Terminated Employees
43. Trigger to Enforce Salary Range
44. Trigger to Log Bonus Changes
45. Trigger to Automatically Set Full Name
46. Trigger to Restrict Updates Based on Role
47. Trigger to Prevent Multiple Active Assignments
48. Trigger to Log Termination Reason
49. Trigger to Prevent Update of Salary for Executives
50. Trigger to Enforce Employee Age Limit
51. Trigger to Log Updates to Employee Address
52. Trigger to Auto-Fill Department on Insert
53. Trigger to Deny Updates During Non-Business Hours
54. Trigger to Log Changes to Contact Information
55. Trigger to Prevent Update of Department for Managers
56. Trigger to Log Updates to Salary
57. Trigger to Enforce Manager Assignment
58. Trigger to Deny Insert of Duplicate Email
59. Trigger to Log Changes to Job ID
60. Trigger to Prevent Update of Manager ID
61. Trigger to Auto-Assign Default Department
62. Trigger to Restrict Updates to Certain Columns
63. Trigger to Enforce Unique Combination of Columns
64. Trigger to Log Deletions
65. Trigger to Enforce Non-Negative Bonus
66. Trigger to Automatically Set Status Based on Date
67. Trigger to Prevent Insert if Department is Full
68. Trigger to Log Changes to Phone Number
69. Trigger to Restrict Updates to Active Employees
70. Trigger to Enforce Salary Based on Job ID
71. Trigger to Log Insertions
72. Trigger to Prevent Updates Based on Date
73. Trigger to Automatically Assign Job ID
74. Trigger to Enforce Unique Phone Number
75. Trigger to Log Updates to Department ID
76. Trigger to Restrict Updates to Salary
77. Trigger to Automatically Set Job ID Based on Department
78. Trigger to Log Changes to Email Address
79. Trigger to Enforce Minimum Age for Employees
80. Trigger to Log Changes to Status
81. Trigger to Prevent Updates to Manager ID
82. Trigger to Automatically Assign Default Manager
83. Trigger to Log Salary Changes
84. Trigger to Prevent Insert if Department is Full (Lower Limit)
85. Trigger to Enforce Maximum Salary Based on Job ID
86. Trigger to Log Department Changes (Audit Table)
87. Trigger to Restrict Deletion of Employees with Active Assignments
88. Trigger to Automatically Set Hire Date
89. Trigger to Log Updates to Manager ID
90. Trigger to Restrict Salary Decrease
91. Trigger to Enforce Unique Combination of Name and DOB
92. Trigger to Log Email Changes
93. Trigger to Restrict Updates to Managers
94. Trigger to Log Phone Number Changes
95. Trigger to Prevent Update if Department is Full
96. Trigger to Enforce Minimum Salary (Higher Threshold)
97. Trigger to Log Updates to Full Name
98. Trigger to Prevent Update if Employee is Inactive
99. Trigger to Enforce Salary Cap Based on Job ID
100. Trigger to Log Department ID Changes
No comments:
Post a Comment