hello!
how to create DML trigger Sync_employee_backup_trigger which synchronise the employee data with their backup table on insert,update and delete employee event
create table scalar function calculate_salary which will return total salary of employees of a department.
Table entries are:
Employee_Id bigint identity (1000,1) PK
First Name nvarchar(64)
Last Name nvarchar(64)
Department_Name nvarchar(128)
Salary decimal (18,5)
// in SQL Server