Tutorial by Examples: an

SQL Query optimizer will choose the baes possible plan that he can find for some query. If you can find some plan that works optimally for some query, you can force QO to always use that plan using the following stored procedure: EXEC sp_query_store_unforce_plan @query_id, @plan_id From this poi...

LINQ extension methods on IEnumerable<T> take actual methods1, whether anonymous methods: //C# Func<int,bool> fn = x => x > 3; var list = new List<int>() {1,2,3,4,5,6}; var query = list.Where(fn); 'VB.NET Dim fn = Function(x As Integer) x > 3 Dim list = New List F...

Add the readonly attribute to prevent user input. A readonly field can't be edited <input class="form-control" type="text" placeholder="Readonly input here…" readonly> Add the disabled attribute to disable an input field. A disbled field can't be edited either...

The $http requests require time which varies depending on the server, some may take a few milliseconds, and some may take up to a few seconds. Often the time required to retrieve the data from a request is critical. Assuming the response value is an array of names, consider the following example: ...

List all the node versions installed nvm ls v4.5.0 v6.7.0 Run command using any node installed version nvm run 4.5.0 --version or nvm exec 4.5.0 node --version Running node v4.5.0 (npm v2.15.9) v4.5.0 nvm run 6.7.0 --version or nvm exec 6.7.0 node --version Running node v6.7.0...

This is the Cypher, Neo4j's query language. In many ways, Cypher is similar to SQL if you are familiar with it, except SQL refers to items stored in a table while Cypher refers to items stored in a graph. First, we should start out by learning how to create a graph and add relationships, since tha...

roslaunch is an important tool that manages the start and stop of ROS nodes. It takes one or more "*.launch" files as arguments. For this example, I will refer to the following (as asked in this question), so how can we execute those commands consecutively & automatically : roscd ste...

Passing ByRef or ByVal indicates whether the actual value of an argument is passed to the CalledProcedure by the CallingProcedure, or whether a reference (called a pointer in some other languages) is passed to the CalledProcedure. If an argument is passed ByRef, the memory address of the argument i...

let bodies = (contact.bodyA.categoryBitMask <= contact.bodyB.categoryBitMask) ? (A:contact.bodyA,B:contact.bodyB) : (A:contact.bodyB,B:contact.bodyA) switch (bodies.A.categoryBitMask,bodies.B.categoryBitMask) { case let (a, _) where (a && superPower): //All we care about is i...

Objective-C First add the Social Framework to the XCode project. Import the #import "Social/Social.h" class to the required ViewController Twitter with text, image and link //- - To Share text on twitter - - if([SLComposeViewController isAvailableForServiceType:SLServiceTypeTwitter]) ...

// myString is "hi" NSMutableString *reversedString = [NSMutableString string]; NSInteger charIndex = [myString length]; while (charIndex > 0) { charIndex--; NSRange subStrRange = NSMakeRange(charIndex, 1); [reversedString appendString:[myString substringWithRange:subS...

Given a money system, is it possible to give an amount of coins and how to find a minimal set of coins corresponding to this amount. Canonical money systems. For some money system, like the ones we use in the real life, the "intuitive" solution works perfectly. For example, if the diffe...

Typically, packages consist of one or more modules. As packages grow, it may be useful to organize the main module of the package into smaller modules. A common idiom is to define those modules as submodules of the main module: module RootModule module SubModule1 ... end module SubModul...

Installation via NodeJS is the recommended method. It is preferred because you can use it to build the files selecting just the components you want. Step 1: Install Node (Link) Step 2: Install Gulp globally ( -g ) on your computer npm install -g gulp Semantic UI uses Gulp to provide command ...

This document details the steps to obtain the facebook access tokens and the using the tokens to fetch FB feeds. Example: A live example is available in https://newtonjoshua.com Introduction to Graph API: The Graph API is the primary way to get data in and out of Facebook's platform. It's a...

Arch: An official pacman-package is available. Install the package as root, using: pacman -S postgis OpenSuse: In order to use the openSuse repositories for geospatial applications, enable the Geo-repository as root: zypper ar http://download.opensuse.org/repositories/Application:/Geo/openSUS...

The navigation pane located at the left hand side of the admin panel is how you navigate to and access different administration functionalities in the OpenCart back end. Pane expander Current account name and role Dashboard Catalog Categories Products Recurring Profiles Filters Attrib...

To generate keys for SSH client: ssh-keygen [-t rsa | rsa1 | dsa ] [-C <comment>] [-b bits] For example: ssh-keygen -t rsa -b 4096 - C [email protected] Default location is ~/.ssh/id_rsa for private and ~/.ssh/id_rsa.pub for public key. For more info, please visit man.openbsd.org

Objective-C //Displays the country pickerView with black background and white text [self. countryPicker setValue:[UIColor whiteColor] forKey:@"textColor"]; [self. countryPicker setValue:[UIColor blackColor] forKey:@"backgroundColor"]; Swift let color1 = UIColor(colorLitera...

This is a porting of set up sourced from DigitalOcean's tutorial of How To Serve Flask Applications with uWSGI and Nginx on Ubuntu 14.04 and some useful git resources for nginx servers. Flask Application This tutorial assume you use Ubuntu. locate var/www/ folder. Create your web app folder m...