Tutorial by Examples: at

Testing against a date range

Although it is very tempting to use BETWEEN ... AND ... for a date range, it is problematical. Instead, this pattern avoids most problems: WHERE x >= '2016-02-25' AND x < '2016-02-25' + INTERVAL 5 DAY Advantages: BETWEEN is 'inclusive' thereby including the final date or second. 2...

MySQL • Date and Time Operations

Generating Date Range With Recursive CTE

Using a Recursive CTE, you can generate an inclusive range of dates: Declare @FromDate Date = '2014-04-21', @ToDate Date = '2014-05-02' ;With DateCte (Date) As ( Select @FromDate Union All Select DateAdd(Day, 1, Date) From DateCte Where Date < @T...

Microsoft SQL Server • Generating a range of dates

Generating a Date Range With a Tally Table

Another way you can generate a range of dates is by utilizing a Tally Table to create the dates between the range: Declare @FromDate Date = '2014-04-21', @ToDate Date = '2014-05-02' ;With E1(N) As (Select 1 From (Values (1), (1), (1), (1), (1), (1), (1), (1), (1), (1)) DT...

Microsoft SQL Server • Generating a range of dates

Recursive list processing with pattern matching

Here we demonstrate how to process lists recursively using OCaml's pattern matching syntax. let rec map f lst = match lst with | [] -> [] | hd::tl -> (f hd)::(map f tl) In this case, the pattern [] matches the empty list, while hd::tl matches any list that has at least one element...

OCaml • Pattern Matching

Official documentation

TYPO3 has extensive documentation. This documentation is linked here, so people can find stuff that is not documented here. Main Documentation The documentation of TYPO3 CMS is collected at docs.typo3.org, there is a list of all documentation for the core, and documentation for extensions. Promin...

typo3 • Links to official documentation Sites

Installation with composer

TYPO3 can be solely installed with the PHP dependency manager composer. Composer has to be available on the server, then a TYPO3 project can be started by using the base distribution. composer create-project typo3/cms-base-distribution . This will pull the TYPO3 core from the git repository, dow...

typo3 • Installation & Setup

Delete duplicate rows using CTE

Microsoft SQL Server • Common Table Expressions

List of Comparison Operators

OperatorComparisonExample==Equali == 0===Equal Value and Typei === "5"!=Not Equali != 5!==Not Equal Value or Typei !== 5>Greater thani > 5<Less thani < 5>=Greater than or equali >= 5<=Less than or equali <= 5

JavaScript • Comparison Operations

Creating a Simple VB.NET WinForms Application using a Text Editor

Open a text editor (like Notepad), and type the code below: Imports System.ComponentModel Imports System.Drawing Imports System.Windows.Forms Namespace SampleApp Public Class MainForm : Inherits Form Private btnHello As Button ' The form's constructor: thi...

winforms • Getting started with winforms

Cross Validation and Tuning with xgboost

library(caret) # for dummyVars library(RCurl) # download https data library(Metrics) # calculate errors library(xgboost) # model ############################################################################### # Load data from UCI Machine Learning Repository (http://archive.ics.uci.edu/ml/data...

R Language • xgboost

Overview of the basic path drawing commands: lines and curves

================== TODO: Link each of the drawing commands below to their individual examples. I don't know how to do this since the links to the individual examples point towards the "draft" folder. TODO: Add examples for these path "action" commands: stroke(), fill(), clip() ...