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...
Thursday, March 18, 2021

.::: Migration Oracle to MSSQL using SQLines Data Migration :::.

›
A. Prepare software migration 1. Download SQLines Data & extract  http://www.sqlines.com/download SQLines Data is a tool for data transf...
Wednesday, March 17, 2021

.::: Migration MariaDB/MySQL to MSSQL using SQLines Data Migration :::.

›
A. Prepare software migration 1. Download SQLines Data & extract  http://www.sqlines.com/download SQLines Data is a tool for data transf...

.::: Migration MariaDB/MySQL to Oracle using SQLines Data Migration :::.

›
A. Prepare software migration 1. Download SQLines Data & extract  http://www.sqlines.com/download SQLines Data is a tool for data transf...
Tuesday, March 9, 2021

.::: Migration SQL Server (MSSQL) to Oracle using SQLines Data Migration :::.

›
A. Prepare software migration 1. Download SQLines Data & extract  http://www.sqlines.com/download SQLines Data is a tool for data transf...