Tutorial by Examples: g

Use EXCEPT to prevent updates to unchanged records MERGE TargetTable targ USING SourceTable AS src ON src.id = targ.id WHEN MATCHED AND EXISTS ( SELECT src.field EXCEPT SELECT targ.field ) THEN UPDATE SET field = src.field WHEN...

If you want to parse more complex command-line arguments, e.g. with optional parameters, than the best is to use google's GWT approach. All classes are public available at: https://gwt.googlesource.com/gwt/+/2.8.0-beta1/dev/core/src/com/google/gwt/util/tools/ToolBase.java An example for handling ...

The power of AppleScript lies in being able to automate many Mac applications. To find out what you can automate, you need to read an app's scripting dictionary. To do so, launch Script Editor, and select File > Open Dictionary… Once you choose an app, its dictionary will open up in a new win...

Most of the guidance for creating good examples for Q&A carries over into the documentation. Make it minimal and get to the point. Complications and digressions are counterproductive. Include both working code and prose explaining it. Neither one is sufficient on its own. Don't re...

// 2. Covariant result version of the base example, static type checking. class Top { public: virtual Top* clone() const = 0; virtual ~Top() = default; // Necessary for `delete` via Top*. }; class D : public Top { public: D* /* ← Covariant return */ clone() const over...

Converts the specified string representation of a date and time to its DateTime equivalent using the specified format, culture-specific format information, and style. The format of the string representation must match the specified format exactly. The method returns a value that indicates whether th...

Return the length of the string in bytes. Since some characters may be encoded using more than one byte, if you want the length in characters see CHAR_LENGTH() Syntax: LENGTH(str) LENGTH('foobar') -- 6 LENGTH('fööbar') -- 8 -- contrast with CHAR_LENGTH(...) = 6

Return the number of characters in the string Syntax: CHAR_LENGTH(str) CHAR_LENGTH('foobar') -- 6 CHAR_LENGTH('fööbar') -- 6 -- contrast with LENGTH(...) = 8

Resource with same path and name may exist in more than one JAR file on the classpath. Common cases are resources following a convention or that are part of a packaging specification. Examples for such resources are META-INF/MANIFEST.MF META-INF/beans.xml (CDI Spec) ServiceLoader properties con...

const md = Rx.Observable.fromEvent(document, 'mousedown').map(true); // `md` will emit `true` whenever the mouse is pressed const mu = Rx.Observable.fromEvent(document, 'mouseup').map(false); // `mu` will emit `false` whenever the mouse is depressed

const source = Rx.Observable.range(1, 3) .map(x => x * x); const subscription = source.subscribe( x => console.log(`Next: ${x}`), err => console.log(`Error: ${err}`), () => console.log(`Completed`) ); // => Next: 1 // => Next: 4 // => Next: 9 // => Compl...

const source = Rx.Observable.range(1, 3) .map((x, idx, obs) => `Element ${x} was at position ${idx}`); const subscription = source.subscribe( x => console.log(`Next: ${x}`), err => console.log(`Error: ${err}`), () => console.log(`Completed`) ); // => Next: Element 1...

In order to get the official I18N Plugin into your CLI Project we need to install it by following the next steps. First you want to install the plugin via npm: npm install aurelia-i18n Since Aurelia-I18N is backed by i18next, you should install it and a backend plugin of your choice. As an exampl...

Often when building a Docker image, the Dockerfile contains instructions that runs programs to fetch resources from the Internet (wget for example to pull a program binary build on GitHub for example). It is possible to instruct Docker to pass set set environment variables so that such programs per...

The received bytes have to be decoded with the correct character encoding to be interpreted as text: Python 3.x3.0 import urllib.request response = urllib.request.urlopen("http://stackoverflow.com/") data = response.read() encoding = response.info().get_content_charset() html = d...

From inside the interative Julia shell (also known as REPL), you can access the system's shell by typing ; right after the prompt: shell> From here on, you can type any shell comand and they will be run from inside the REPL: shell> ls Desktop Documents Pictures Templates Downloa...

The simplest way is to use brew: brew install zsh After installation, you may want to set it as your default shell by doing: sudo echo '/usr/local/bin/zsh' >> /etc/shells chsh -s /usr/local/bin/zsh If you have git, and required command line tools installed you can compile and install ...

brew install zsh sudo echo '/usr/local/bin/zsh' >> /etc/shells chsh -s /usr/local/bin/zsh

In Smalltalk almost everything you do is sending messages to objects (referred as calling methods in other languages). There are three types of messages: Unary messages: #(1 2 3) size "This sends the #size message to the #(1 2 3) array. #size is a unary message, because it takes no argumen...

You can create extension methods to improve usability for nested collections like a Dictionary with a List<T> value. Consider the following extension methods: public static class DictListExtensions { public static void Add<TKey, TValue, TCollection>(this Dictionary<TKey, TColl...