Skip to content

Instantly share code, notes, and snippets.

@MinaMal
MinaMal / RealPars RSLinx Sample Excel File .xlsm
Last active April 6, 2020 14:44
RealPars RSLinx Sample Excel File
/* Timer01 Miliseconds */
=RSLINX|RealParsExcel!'Timer01.ACC,L1,C1'
/* Timer01 Seconds */
=D2/1000
@MinaMal
MinaMal / SQL UNION Example.sql
Created March 15, 2020 05:47
SQL UNION Example
SELECT ID FROM t1
UNION
SELECT ID FROM t2;
@MinaMal
MinaMal / INSERT INTO Example.sql
Created March 15, 2020 05:47
INSERT INTO Example
INSERT INTO t1 VALUES (1), (2), (3);
INSERT INTO t2 VALUES (2), (3), (4);
@MinaMal
MinaMal / CREATE TABLE Ex.sql
Created March 15, 2020 05:46
CREATE TABLE Ex
CREATE TABLE t1 (ID INT PRIMARY KEY);
CREATE TABLE t2 (ID INT PRIMARY KEY);
@MinaMal
MinaMal / DROP TABLE Example.sql
Created March 15, 2020 05:43
DROP TABLE Example
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
@MinaMal
MinaMal / INNER JOIN Example.sql
Created March 15, 2020 05:43
INNER JOIN Example
SELECT t1.ID, t2.ID
FROM t1 INNER JOIN t2
ON t1.Pattern = t2.Pattern;
@MinaMal
MinaMal / CROSS JOIN Example.sql
Created March 15, 2020 05:42
CROSS JOIN Example
SELECT t1.ID, t2.ID
FROM t1 CROSS JOIN t2;
@MinaMal
MinaMal / SQL INSERT INTO .sql
Created February 26, 2020 13:46
SQL INSERT INTO
INSERT INTO t2 (ID, Pattern)
VALUES ('A', 'Brick'), ('B', 'Grid'), ('C', 'Diamond');
@MinaMal
MinaMal / INSERT INTO .sql
Created February 26, 2020 13:45
INSERT INTO
INSERT INTO t1 (ID, Pattern)
VALUES (1, 'Divot'), (2, 'Brick'), (3, 'Grid');
@MinaMal
MinaMal / CREATE TABLE Examples .sql
Created February 26, 2020 13:45
CREATE TABLE Examples
CREATE TABLE t2 (
ID VARCHAR(50) PRIMARY KEY,
Pattern VARCHAR(50) NOT NULL);