Tutorial by Examples: et

Using COALESCE to Build Comma-Delimited String

We can get a comma delimited string from multiple rows using coalesce as shown below. Since table variable is used, we need to execute whole query once. So to make easy to understand, I have added BEGIN and END block. BEGIN --Table variable declaration to store sample records DECLARE @...

Delete duplicate rows using CTE

Employees table : | ID | FirstName | LastName | Gender | Salary | +------+-----------+----------+--------+--------+ | 1 | Mark | Hastings | Male | 60000 | | 1 | Mark | Hastings | Male | 60000 | | 2 | Mary | Lambeth | Female | 30000 | | 2 | Mary | Lambe...

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

lineTo (a path command)

context.lineTo(endX, endY) Draws a line segment from the current pen location to coordinate [endX,endY] <!doctype html> <html> <head> <style> body{ background-color:white; } #canvas{border:1px solid red; } </style> <script> window.onload=(fun...

quadraticCurveTo (a path command)

context.quadraticCurveTo(controlX, controlY, endingX, endingY) Draws a quadratic curve starting at the current pen location to a given ending coordinate. Another given control coordinate determines the shape (curviness) of the curve. <!doctype html> <html> <head> <style...

bezierCurveTo (a path command)

context.bezierCurveTo(control1X, control1Y, control2X, control2Y, endingX, endingY) Draws a cubic Bezier curve starting at the current pen location to a given ending coordinate. Another 2 given control coordinates determine the shape (curviness) of the curve. <!doctype html> <html&gt...

With NetStatusEvent

package { import flash.events.NetStatusEvent; import flash.net.NetStream; import flash.net.NetConnection; import flash.events.Event; import flash.media.Video; import flash.display.Sprite; public class VideoWithNetStatus extends Sprite { private var video:V...

Elementary set operations

It's possible to perform elementary set operations with Matlab. Let's assume we have given two vectors or arrays A = randi([0 10],1,5); B = randi([-1 9], 1,5); and we want to find all elements which are in A and in B. For this we can use C = intersect(A,B); C will include all numbers which ...

Installation or Setup

Linux Requirements (r0.16.0) Mandatory As per current Apache-Pig documentation it supports only Unix & Windows operating systems. Hadoop 0.23.X, 1.X or 2.X Java 1.6 or Later versions installed and JAVA_HOME environment variable set to Java installation directory Optional Python 2.7 ...

Putting the Future Together

The previous examples demonstrated the individual features of a Future, handling success and failure cases. Usually, however, both features are handled much more tersely. Here's the example, written in a neater and more realistic way: object Calculator { def calculateAndReport(a: Int, b: Int...

Customize the VM Option

You can override the default vmoptions with your own personal settings by choosing Help > Edit Custom VM Options from the Android Studio toolbar. This will create a local copy which you are free to edit. Alternatively, you can edit the default vmoptions directly using the paths given below. Note...

Adding a metadata endpoint to your service

SOAP services can publish metadata that describes the methods that may be invoked by clients. Clients can use tools such as Visual Studio to automatically generate code (known as client proxies). The proxies hide the complexity of invoking a service. To invoke a service, one merely invokes a metho...

Multiple transformations

Transformations can be concatenated and are applied right to left Rotate a rectangle by 90 degrees and then move it down by 20 units and to the right by 20 units: <svg xmlns="http://www.w3.org/2000/svg"> <rect x="-10" y="-20" width="20" height=...

Showing code snippets and output

Two popular options are to use: ipython notation: In [11]: df = pd.DataFrame([[1, 2], [3, 4]]) In [12]: df Out[12]: 0 1 0 1 2 1 3 4 Alternatively (this is popular over in the python documentation) and more concisely: df.columns # Out: RangeIndex(start=0, stop=2, step=1) df[0...

Installation or Setup

Detailed instructions on getting artifactory set up or installed.

<svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"> <rect x="50" y="50" height="100" width="100" stroke="black" fill="yellow"> <animateTransform a...

Blur Filters: feGaussianBlur (x-axis and y-axis blur set separately)

<svg width="900px" height="400px" viewBox="0 0 900 400"> <defs> <filter id="xAxisGaussian"> <feGaussianBlur stdDeviation="5 0"/> </filter> </defs> <image xlink:href=...
SVG • Filters

Getting current battery level

// Get the battery API navigator.getBattery().then(function(battery) { // Battery level is between 0 and 1, so we multiply it by 100 to get in percents console.log("Battery level: " + battery.level * 100 + "%"); });

Get time left until battery is empty

// Get the battery API navigator.getBattery().then(function(battery) { console.log( "Battery will drain in ", battery.dischargingTime, " seconds" ); });

Get time left until battery is fully charged

// Get the battery API navigator.getBattery().then(function(battery) { console.log( "Battery will get fully charged in ", battery.chargingTime, " seconds" ); });

Page 77 of 258

logo rip
SUPPORT & PARTNERS
STAY CONNECTED

Get monthly updates about new articles, cheatsheets, and tricks.