Tutorial by Examples: i

Coalesce basic Example

COALESCE() returns the first NON NULL value in a list of arguments. Suppose we had a table containing phone numbers, and cell phone numbers and wanted to return only one for each user. In order to only obtain one, we can get the first NON NULL value. DECLARE @Table TABLE (UserID int, PhoneNumber va...

Microsoft SQL Server • COALESCE

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

Test if cookies are enabled

If you want to make sure cookies are enabled before using them, you can use navigator.cookieEnabled: if (navigator.cookieEnabled === false) { alert("Error: cookies not enabled!"); } Note that on older browsers navigator.cookieEnabled may not exist and be undefined. In those case...

JavaScript • Cookies

Factorials

Function Factorial(Value As Long) As Long If Value = 0 Or Value = 1 Then Factorial = 1 Else Factorial = Factorial(Value - 1) * Value End If End Function

VBA • Recursion

Folder Recursion

Early Bound (with a reference to Microsoft Scripting Runtime) Sub EnumerateFilesAndFolders( _ FolderPath As String, _ Optional MaxDepth As Long = -1, _ Optional CurrentDepth As Long = 0, _ Optional Indentation As Long = 2) Dim FSO As Scriptin...

VBA • Recursion

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

Find nth highest salary using CTE

Microsoft SQL Server • Common Table Expressions

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

Benchmarking using microbenchmark

You can use the microbenchmark package to conduct "sub-millisecond accurate timing of expression evaluation". In this example we are comparing the speeds of six equivalent data.table expressions for updating elements in a group, based on a certain condition. More specifically: A data....

R Language • Code profiling

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() ...