Create insert/update/Delete trigger for the Employee_Details table and log the information like Table Name, Action Name, current system user, current date, and the primary key value to the DB_Action table
computer science
Description
2. Create insert/update/Delete trigger for the Employee_Details table and log the information like Table Name, Action Name, current system user, current date, and the primary key value to the DB_Action table.
3. Create a combined procedure for insert/update/delete for the table Employee_Details according to the flag value.
If Flag value is 1, procedure will do insertion, 2 update and 3 Delete.
4. Create a transaction (in Stored Procedure) for inserting a record into Employee_Details table, then fetch the primary key value generated and insert all his document details including the primary key value from first table to Employee_Documents table. All these operations should be in a single transaction.
6. Implement an error logging mechanism in the procedure of Requirement no.4 and log the information mentioned in above table.
15. Create a dynamic SQL procedure for searching all employees from employee details table.
Search Parameters (The user may input none or one or multiple values into the parameters you set up in the stored procedure):
First name, Last name, Middle name, Designation name, Country name, Start DOB, End DOB, start DOJ, End DOJ.
Result:
First name, Middle name, Last name, Country, State, City, Designation, DOB, DOJ, Gender
Instruction Files
question.docx
12.9 KB
