Arkadiusz arekgotfryd

👽

Working from home

30 followers · 63 following

Bielsko-Biała

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

arekgotfryd / Update sql table column with values from other table using spatial method contains to find the link between tables

Last active February 19, 2019 09:45

	UPDATE a
	set a.Score = _TARGET.Score
	FROM McD_ROI_Hex_All_Afternoon a
	JOIN [SandBox].dbo.[McD_ROI_Hex_Timebuckets] AS _TARGET
	ON a.SP_GEOMETRY.STContains(_TARGET.SP_GEOMETRY) = 1
	AND a.Sum_Avg_Users = _TARGET.Sum_Avg_Users;

arekgotfryd / gist:8d01135f44882b93677b9a83a010dbbb

Created February 8, 2019 08:44

sql-server-add-auto-increment-primary-key-to-existing-table

	ALTER TABLE dbo.YourTable
	ADD ID INT IDENTITY
	CONSTRAINT PK_YourTable PRIMARY KEY CLUSTERED

arekgotfryd / gist:4bf2566f430fa42ed20d7b1e1f31c964

Created November 28, 2018 13:05

TITLE: Microsoft SQL Server Management Studio Cannot execute script. ADDITIONAL INFORMATION: Insufficient memory to continue the execution of the program. (mscorlib)

	Use sqlcmd tool just like below:

	SQLCMD -S TestSQLServer\SQLEXPRESS -U sa -P sasa -d AdventureWorks2018 -i "d:\document\sql document\script.sql"

arekgotfryd / How to create Spatial Index in SQL Server

Created November 28, 2018 13:03

	1. Create table with PRIMARY_KEY
	CREATE TABLE dbo.AuditLog
	(
	AuditLogID int constraint PK_AuditLog_AuditLogID primary key
	)

	2. Create table with unique clustered

	CREATE UNIQUE CLUSTERED INDEX PK_AuditLog_AuditLogID
	ON dbo.AuditLog(AuditLogID)

arekgotfryd / How to find rows which contain single character

Created November 14, 2018 14:29

	SELECT [SUBURB]
	,[COLUMN_TYPE]
	,[HEIGHT]
	,[COLUMN_MATERIAL]
	,[OUTREACH_ARM_LENGTH]
	,[LUMINAIRE]
	,[LAMP_TYPE]
	,[LAMP_COUNT]
	,[LAT]
	,[LON]

arekgotfryd / BULK INSERT

Created November 14, 2018 13:57

+  BULK INSERT dbo.output
+    FROM 'F:\Temp\Prezka\transformData\output2.csv'
+    WITH
+    (
+    FIRSTROW = 2,
+    FIELDTERMINATOR = ',',  --CSV field delimiter
+	ROWTERMINATOR = '0x0a', -- \n
+	ERRORFILE = 'F:\Temp\Prezka\transformData\errors.csv',
+    TABLOCK
+    )

arekgotfryd / Generate random decimal numbers (2 places precision) between 5 and 10

Created October 23, 2018 20:16

UPDATE online_bookstore.book SET unit_price = TRUNCATE(RAND()*(10-5)+5,2);

arekgotfryd / Fill Geometry::Point column with Point geometry created from coordinates which exists in the same table

Created October 11, 2018 08:04

UPDATE [YOUR_TABLE] SET [POINT_GEOM] = geometry::STPointFromText('POINT(' + CAST([X] AS VARCHAR(20)) + ' ' + CAST([Y] AS VARCHAR(20)) + ')', 4326);

arekgotfryd / refined2

Created February 28, 2018 21:27

	var mongoose = require(mongoose),
	User = require(./user-model);

	var connStr = mongodb://localhost:27017/mongoose-bcrypt-test;
	mongoose.connect(connStr, function(err) {
	if (err) throw err;
	console.log(Successfully connected to MongoDB);
	});

	// create a user a new user

arekgotfryd / refined

Created February 28, 2018 21:25

	var mongoose = require("mongoose");
	var bcrypt = require("bcrypt");
	var Schema = mongoose.Schema;
	const SALT_WORK_FACTOR = 10;

	var UserSchema = new Schema({
	email: { type: String, required: true, index: { unique: true } },
	password: { type: String, required: true }
	});

Newer Older