SISTEM INFORMASI

Function

Jibril Oktober 06, 2022

1. Membuat Function Table CREATE FUNCTION fn_EmpDept ( @ID INT ) RETURNS TABLE AS RETURN ( SELECT NIK, A.Name AS NAMA, Addreess AS Alamat, ...

SQL

Jibril Oktober 06, 2022

1. Membuat Store Procedure sebagai menampilkan data CREATE PROCEDURE sp_EmployeeDept @ID NVARCHAR(20) AS BEGIN SELECT NIK, A.Name AS NAMA, ...

SQL

Jibril Oktober 06, 2022

1. Membuat Trigger Insert CREATE TRIGGER Tot_employee ON t_Employees AFTER INSERT AS BEGIN Declare @tot_emp int, @department int Select @de...

Jibril Oktober 06, 2022

1. Membuat View CREATE VIEW Nama_View As Ekspresi_SELECT CREATE VIEW vEmployee AS SELECT NIK, Name, Addreess, City, Salary FROM t_Employees...

Created By SoraTemplates | Distributed By Gooyaabi Templates