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

Ramesh Maruthi · Answer

USE [Employee]-- Database Name GO /****** Object: UserDefinedFunction [dbo].[UDF_CalculateSalary ] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[UDF_CalculateSalary] RETURNS @Employees TABLE(Department_Name nvarchar(128) Salary decimal(185)) AS BEGIN Insert Into @Employees(Department_NameSalary ) SELECT Department_Name SUM(Salary)FROM employees GROUP BY Department_Name RETURN END GO