Stefan Steiger ststeiger

😎

Back from holidays

¡ slᴉɐɯǝ ɹnoʎ pɐǝɹ I

ststeiger / TypeScript_Example.ts

Last active September 16, 2015 07:14

TypeScript usage example

ststeiger / TypeScript_Constructs.ts

Last active September 16, 2015 07:13

Various TypeScript constructs


	// No bug on jQuery and external reference $$
	declare var $:any;
	declare var $$:any;


	// http://stackoverflow.com/questions/14980014/how-can-i-calculate-the-time-between-2-dates-in-typescript
	// var time = new Date() - new Date("2013-02-20T12:01:04.753Z");
	var time = new Date().getTime() - new Date("2013-02-20T12:01:04.753Z").getTime();

ststeiger / ParameterExtension.vb_cs

Created September 17, 2015 12:03

Get Parameter from POST/GET/HEADER for ASP.NET vNext


	namespace AspNetVnextUtils
	{


	public static class ParameterExtensions
	{

	private static System.Reflection.FieldInfo InitFieldInfo()
	{

ststeiger / DropCreate_DateFromToConstraint.sql

Created September 23, 2015 07:31

Drop and re-create DateFrom/DateTo constraints (WHERE SoftDelete-Status = 1) if table exists


	SELECT
	--table_name
	--,column_name,
	--,' SELECT ''' + REPLACE(table_name, '''', '''''') + ''' AS tableName, * FROM ' + QUOTENAME(table_name) + ' WHERE ' + QUOTENAME(column_name) + ' > ' + REPLACE(QUOTENAME(column_name), 'Von', 'Bis') + '; ' AS cmd

	--,
	'

ststeiger / EasyAjax.js

Created September 24, 2015 15:32

Easy wrapper for AJAX, including defered WITHOUT jQuery


	// Avoid `console` errors in browsers that lack a console.
	(function ()
	{
	var method;
	var noop = function () { };
	var methods = [
	'assert', 'clear', 'count', 'debug', 'dir', 'dirxml', 'error',
	'exception', 'group', 'groupCollapsed', 'groupEnd', 'info', 'log',
	'markTimeline', 'profile', 'profileEnd', 'table', 'time', 'timeEnd',

ststeiger / EasyAjax.ts

Created September 24, 2015 15:32

EasyAjax TypeScript source


	declare var REQ: any;


	namespace Http
	{

	export abstract class RequestBase
	{
	public url: string;

ststeiger / MultiFilter.sql

Last active October 6, 2015 14:59

Filter IN on "array" in SQL-Server


	DECLARE @SO_UIDs varchar(MAX);

	SET @SO_UIDs = 'F2808163-C192-4860-9C32-2514F880F123,DDCC699D-B525-4DA3-A558-3BE87AA8923A,043AB989-AA6C-4621-AF26-44C9D537483B,DB14B864-6F96-41B9-BD22-51EAEABC46B9,60DF0FF4-AC1E-4526-8511-653F07CB19C3';
	-- SET @SO_UIDs = '81f82b66-5cc1-4985-869f-cade014fb4a4';
	-- SET @SO_UIDs = NULL
	-- SET @SO_UIDs = '00000000-0000-0000-0000-000000000000';


	DECLARE @tXML xml;

ststeiger / MultiValueParameterQuery.sql

Last active April 18, 2019 09:57

Multi-Value Parameter directly in SQL from string.Join(array, ",")


	CREATE FUNCTION [dbo].[tfu_RPT_SEL_FromXML]
	(
	@in_xml xml
	)
	RETURNS TABLE
	AS
	RETURN
	(
	SELECT tempNodes.innerXML.value('.', 'varchar(36)') AS val

ststeiger / AddPK.sql

Last active October 23, 2015 09:27

Adding a primary key to table in a fault-tolerant manner


	IF 0 < (
	SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_TYPE = 'BASE TABLE'
	AND TABLE_SCHEMA = 'dbo'
	AND TABLE_NAME = 'T_SYS_Language_Forms'
	)
	BEGIN
	-- Check for NULL values in the primary-key column
	IF 0 = (SELECT COUNT(*) FROM T_SYS_Language_Forms WHERE LANG_UID IS NULL)

ststeiger / Add_PK_pgsql.sql

Created October 21, 2015 11:47

Adding a primary key to table in a fault-tolerant manner (PostgreSQL)


	DO $$
	DECLARE __mytext character varying(200);
	BEGIN
	__mytext := 'Test message';
	--RAISE NOTICE __mytext;
	RAISE NOTICE '%', __mytext;
	RAISE NOTICE '% %', 'arg1', 'arg2';