Wednesday, June 30, 2021

.::: Implementation Store Procedure on Datawarehouse SQL Server ( Sample table barang, customer, suplier, pasok & pembelian) :::.

›
  1. add table barang -- if using Query SQL select * from barang; insert into barang(KODE_BARANG,NAMA_BARANG,SATUAN_BARANG,STOK_BARANG) valu...

.::: Create table Inventory Datawarehouse SQL Server Original (Converting script from SQL Studio :::.

›
A. Create Database & Table  create database teguhth go 1. Table barang -- table barang with index CREATE TABLE [dbo].[barang]( [KODE_B...
Monday, June 28, 2021

.::: Create Stored Procedure & Function Using SQL Server (Sample database moonton Mobile Legend) :::.

›
Stored Procedure Stored Procedure merupakan sekumpulan perintah-perintah SQL yang tersimpan dengan nama tertentu dan diproses sebagai sebuah...
Thursday, June 24, 2021

.::: Basic Store Procedure SQL Server :::.

›
1. Sample 1 -- SQL Query 1 select kode_barang, stok_barang from barang; -- Store Procedure 1 create procedure kodestokbarang  as  select kod...
Thursday, May 20, 2021

.::: Create Linked Server MSSQL to use Open Query (to another MSSQL) insert, update, delete :::.

›
A. Preconfigurasi 1. Konfiguration ODBC Data Source (64) No Need Configuration ODBC 2. create Linked Server Server Objects -> Linked Serv...

.::: Create Linked Server MSSQL to use Open Query (Oracle) insert, update, delete :::.

›
A. Preconfigurasi 1. Konfiguration ODBC Data Source (64) No Need Configuration ODBC 2. create Linked Server Server Objects -> Linked Serv...
Monday, May 3, 2021

.::: Create Linked Server MSSQL to use Open Query (MariaDB/MySQL) insert, update, delete :::.

›
A. Preconfigurasi 1. Konfiguration ODBC Data Source (64) system DSN > Add >> MySQL ODBC 5.3 ANSI Driver Connection Parameters Data ...
Wednesday, April 14, 2021

.::: How to backup and restore table & database Oracle :::.

›
A. Backup & Restore table Oracle 1. Backup Table Database oracle  exp aisyah/hanin@tka tables=pasok file="D:\labolatorium\oracle\ba...
Thursday, April 8, 2021

.::: Sample Aljabar(Algebra) Iner join, normal join, equal join(=),left outer join and right outer join In SQL :::.:::.

›
1. join/normal join/equal join(=) bertujuan untuk mencari kesamaan data antara table yang satu dengan table yang lain xxxxxxxxxxxxxxxxxxxxxx...
Wednesday, April 7, 2021

.::: Sample Aljabar(Algebra): union(gabungan), intersection(irisan), MINUS (difference), distinct (proyeksi) In SQL :::.

›
1. UNION (Combine/gabungan) union bertujuan menggabungkan dua query atau lebih menjadi satu kesatuan query dengan syarat query/subquery yang...
Tuesday, April 6, 2021

.::: Sample Query, Sub Query from one table or More in SQL :::.

›
1. select one table select * from BARANG; select * from SUPLIER; select * from PASOK; 2. select more table select BARANG.NAMA_BARANG, PASOK....

.::: Sample min, max, avg, sum, count, Group by, order by, Having, where, comparison (=,<>,>,<,>= atau <=), Between, In, like / not like on Grouping, Sorting & Criteria Data SQL :::.

›
1. pengelompokan data (group by) dan aggregation function select * from PASOK; select KODE_BARANG as KD_BRG, min(JUMLAH_PASOK) as MINIMUM_PA...
Tuesday, March 30, 2021

.::: How To Add Column, Update, Insert & Delete row table on SQL example MariaDB :::.

›
1. Check original table Barang 2. Add Column table Barang (add KETERANGAN) 3. update row table ( update/fill column keterangan) 4. delete ro...