Tutorial by Examples: in

FOR XML PATH and STUFF to concatenate the multiple rows into a single row: select distinct t1.id, STUFF( (SELECT ', ' + convert(varchar(10), t2.date, 120) FROM yourtable t2 where t1.id = t2.id FOR XML PATH ('')) , 1,...

Ubuntu binaries are available for both 32-bit and 64-bit architectures source /etc/lsb-release && echo "deb http://download.rethinkdb.com/apt $DISTRIB_CODENAME main" | sudo tee /etc/apt/sources.list.d/rethinkdb.list wget -qO- https://download.rethinkdb.com/apt/pubkey.gpg | sudo a...

Downloading Prerequisites: We provide native 64-bit binaries for Windows 7 and above. A 64-bit version of Windows is required. Download the ZIP archive and unpack it in a directory of your choice. The Windows port of RethinkDB is a recent addition and hasn't received as much tuning as the Linux a...

C source file gcc -Wall -Wextra -o main main.c C++ source file g++ -Wall -Wextra -Wconversion -Woverloaded-virtual -o main main.cpp

The Firebase auth system is the source of a users uid, displayName, photoURL, and maybe email. Password based accounts set these persistent values in the auth system via the .updateProfile method. Storing these values in the Realtime Database, rDB, users node poses the issue of stale data. Displa...

package com.example; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class Application { //main entry point public static void main(String[] args) { SpringApplication.run...

package com.example.domain; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; //simple person object with JPA annotations @Entity public class Person { @Id @GeneratedValue(strategy=GenerationType.AUTO) private Long id; ...

package com.example.domain; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.repository.query.Param; import org.springframework.data.rest.core.annotation.RepositoryRestResource; import org.springframework.data.rest.core.annotation.RestResource; /...

Let we assume we have two databases "ORA1" and "ORA2". We can access the objects of "ORA2" from database "ORA1" using a database link. Prerequisites: For creating a private Database link you need a CREATE DATABASE LINK privilege. For creating a private Data...

QML came with rich set of visual elements. Using only QML we can build complex applications with these elements. Also it's very easy to build your own element based on set of standard items like Rectangle, Button, Image etc. Moreover, we can use items like Canvas to build element with custom paint...

Goto - http://www.jorambarrez.be/blog/2010/08/02/tutorial-a-bpmn-2-0-hello-world-with-activiti-5-0-alpha4-in-5-steps/ A very Good and detailed tutorial by Joram Barrez (one of the core Developer of Activiti)

Plugins are a way for a developer to modify a chart as it is being created. Chart.js calls all plugins at the following chart states: Start of initialization End of initialization Start of update After the chart scales have calculated Start of datasets update End of datasets update End of u...

Create horizontal lines with a label. This could be used to show notable values in the chart data (e.g. min, max, average). JSFiddle Demo var horizonalLinePlugin = { afterDraw: function(chartInstance) { var yScale = chartInstance.scales["y-axis-0"]; var canvas = chartInstance...

Source Code Blog

To set a custom row height, override UITableViewSource.GetHeightForRow(UITableView,NSIndexPath): public class ColorTableDataSource : UITableViewSource { List<DomainClass> Model { get; set; } public override nfloat GetHeightForRow(UITableView tableView, NSIndexPath indexPath) ...

Create a folder Create an index.html inside the new directory. Open it in the Bracket editor Download the Phaser repository from github, then grab the phaser.js file from the build folder. Place the file inside your project directory. Open index.html and link the phaser.js inside the header tag...

bash

#!/usr/bin/env node var fs = require('fs'); var path = require('path'); var jshint = require('jshint').JSHINT; var async = require('async'); var foldersToProcess = [ 'js' ]; foldersToProcess.forEach(function(folder) { processFiles("www/" + folder); }); function proce...

Insert the following function call within your JavaScript when searching within your website to track how visitors are using your internal search features. In this example, the Event Action filters is a comma-delimited list of search filter name/value pairs, and the Event Label orderedBy is a strin...

Adding a product to a shopping cart (Label item.name references the name property of the product added): ga('send', 'event', 'Cart', 'Add', product.name); This lets you see what people are adding to the shopping cart, even if they never complete the order, allowing more insight into where users ...