Skip to content

Instantly share code, notes, and snippets.

View MarioBinder's full-sized avatar
:octocat:
.

Mario Binder MarioBinder

:octocat:
.
21 followers · 35 following
View GitHub Profile
@MarioBinder
MarioBinder / replace_in_SQL.sql
Last active December 14, 2017 06:44
replace in sql
-- replaced the first old characters with new signs
update [DATABASE].[dbo].[TABLE] set COLUMN = stuff(COLUMN, 1, 12, 'E:\Daten\LIVE\')
@MarioBinder
MarioBinder / set_database_offline_online.sql
Last active December 14, 2017 06:44
set database offline-online
--offline
USE master
GO
ALTER DATABASE dbname
SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
--online
USE master
GO
@MarioBinder
MarioBinder / connect_API.js
Created December 17, 2017 14:12
How to connect a REST API with JavaScript
var request = new XMLHttpRequest();
request.open('GET', 'https://api_deepli.nk', true);
request.onload = function () {
// Begin accessing JSON data here
var data = JSON.parse(this.response);
if (request.status >= 200 && request.status < 400) {
data.forEach(movie => {
@MarioBinder
MarioBinder / EscapeUnderscoreIn.sql
Created January 4, 2018 15:24
Escape Underscore In MSSQL
select*
FROM TABLE
WHERE username like '%\_del' ESCAPE '\'
@MarioBinder
MarioBinder / cast_as_date_as_time.sql
Created February 15, 2018 07:16
sql - select where date or time
cast([timeStamp] as date) = '2018-02-16' and
cast([timeStamp] as time) >= '06:00:00.000' and cast([timeStamp] as time) <= '07:00:00.000'
@MarioBinder
MarioBinder / cookieHandling.js
Created April 16, 2018 08:33
Create & Read Cookies
//via: http://clubmate.fi/setting-and-reading-cookies-with-javascript/
// Create cookie
function createCookie(name, value, days) {
var expires;
if (days) {
var date = new Date();
date.setTime(date.getTime() + (days * 24 * 60 * 60 * 1000));
expires = "; expires=" + date.toGMTString();
}
else {
@MarioBinder
MarioBinder / linkedServer.sql
Created May 14, 2018 06:03
Linked Server
EXEC sp_addlinkedserver @server='192.168.2.6' -- server hinzufügen
EXEC sp_addlinkedsrvlogin '192.168.2.6', 'false', NULL, 'USER', 'PASSWORD' -- credentials zuweisen
@MarioBinder
MarioBinder / web conferencing tools
Last active May 14, 2018 06:06
web conferencing tools
## web conferencing tools
+ [vyew](http://vyew.com/s/)
+ [onwebinar](http://www.onwebinar.com/)
+ [meetingburner](https://www.meetingburner.com/)
+ [big blue button](http://bigbluebutton.org/overview/)
+ [managemeet](https://www.managemeet.com/)
+ [sync](http://sync.in/)
+ [show document](http://www.showdocument.com/)
+ [webhuddle](https://www.webhuddle.com/)
+ [anymeeting](http://www.anymeeting.com/)
@MarioBinder
MarioBinder / index.html
Created August 17, 2018 06:20
Electron Fiddle Gist
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Hello World!</title>
</head>
<body>
<h1>Hello World!</h1>
<!-- All of the Node.js APIs are available in this renderer process. -->
We are using Node.js <script>document.write(process.versions.node)</script>,
@MarioBinder
MarioBinder / git_remove_ignored_files
Created October 29, 2018 08:44
How to make Git “forget” about a file that was tracked but is now in .gitignore?
git rm -r --cached .
git add .
git commit -am "Remove ignored files"
//via https://stackoverflow.com/a/19095988/119109