SQL server

Question

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