Skip to content

Instantly share code, notes, and snippets.

View ststeiger's full-sized avatar
😎
Back from holidays

Stefan Steiger ststeiger

😎
Back from holidays
154 followers · 3 following
  • Switzerland
View GitHub Profile
@ststeiger
ststeiger / BracketingOnStatement.sql
Last active February 18, 2016 14:31
Bracketing in SQL ON-Statements
SELECT *
FROM T_Site AS St1
LEFT JOIN T_Site AS St2
LEFT JOIN T_Building
ON BD_ST_UID = St2.ST_UID
ON St2.SO_UID = St1.ST_UID
-- Is the same as
@ststeiger
ststeiger / Check_Column_Usage.sql
Created February 19, 2016 14:58
Check if a column is used in a view, procedure, scalar or table-valued function
;WITH CTE AS (
SELECT table_name AS obj_name, OBJECT_DEFINITION(OBJECT_ID(table_name)) AS obj_def FROM INFORMATION_SCHEMA.VIEWS
UNION ALL SELECT specific_name AS obj_name , OBJECT_DEFINITION(OBJECT_ID(specific_name)) AS obj_def FROM INFORMATION_SCHEMA.ROUTINES
)
SELECT * FROM CTE
WHERE (1=2)
OR obj_def LIKE '%AutoNr%'
OR obj_def LIKE '%copyView%'
@ststeiger
ststeiger / Trustworthy.sql
Last active March 1, 2016 16:29
Check trustworthy databases
SELECT
name
,is_trustworthy_on
,compatibility_level
,snapshot_isolation_state_desc
,recovery_model_desc
--,*
FROM sys.databases
WHERE (1=1)
@ststeiger
ststeiger / HideColumns.htm
Created March 18, 2016 12:43
Hide multiple columns in HTML table
<!doctype html>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta charset="utf-8" />
<meta http-equiv="cache-control" content="max-age=0" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="expires" content="0" />
@ststeiger
ststeiger / SearchInViewsFunctionsProcedures.sql
Created March 18, 2016 14:07
Search View/Function/Procedure-Definition Text in SQL-Server
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_SCHEMA_SearchInViewsFunctionsProcedures]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_SCHEMA_SearchInViewsFunctionsProcedures]
GO
-- ======================================================
-- Author: Stefan Steiger
@ststeiger
ststeiger / SolarInfo.cs
Created March 20, 2016 18:16 — forked from cstrahan/SolarInfo.cs
A sunrise/sunset calculator.
using System;
using System.Diagnostics;
namespace SunriseCalculator
{
public class SolarInfo
{
public double SolarDeclination { get; private set; }
public TimeSpan EquationOfTime { get; private set; }
public DateTime Sunrise { get; private set; }
@ststeiger
ststeiger / LinkModifier.ts
Created March 23, 2016 16:28
Modify a HTTP/HTTPS-Link
class LinkModifier {
m_originalLink: string;
m_baseUrl:string;
m_vars: string[];
constructor(link: string) {
this.m_originalLink = link;
this.getUrlVars(this.m_originalLink);
@ststeiger
ststeiger / fcgiclient.go
Created March 29, 2016 12:00 — forked from wofeiwo/fcgiclient.go
Golang FastCGI Client
// Copyright 2012 Junqing Tan <ivan@mysqlab.net> and The Go Authors
// Use of this source code is governed by a BSD-style
// Part of source code is from Go fcgi package
// Fix bug: Can't recive more than 1 record untill FCGI_END_REQUEST 2012-09-15
// By: wofeiwo
package fcgiclient
import (
@ststeiger
ststeiger / ClipboardHelper.cs
Created March 30, 2016 11:22
Get a System.Drawing.Image from the Windows Clipboard
namespace TestWindowsApplicaton
{
public class ClipboardHelper
{
private const uint CF_METAFILEPICT = 3;
@ststeiger
ststeiger / StringReverse.go
Last active March 30, 2016 14:29
How to correctly reverse a string (GraphemeClusters)
package main
import (
"unicode"
"regexp"
)
func main() {
str := "\u0308" + "a\u0308" + "o\u0308" + "u\u0308"
println("u\u0308" + "o\u0308" + "a\u0308" + "\u0308" == ReverseGrapheme(str))