Tutorial by Examples

One problem with the PIVOT query is that you have to specify all values inside the IN selection if you want to see them as columns. A quick way to circumvent this problem is to create a dynamic IN selection making your PIVOT dynamic. For demonstration we will use a table Books in a Bookstore’s dat...

program WhileEOF; {$APPTYPE CONSOLE} uses SysUtils; const cFileName = 'WhileEOF.dpr'; var F : TextFile; s : string; begin if FileExists( cFileName ) then begin AssignFile( F, cFileName ); Reset( F ); while not Eof(F) do begin ...

This sample used to common function for all type object serialization and deserialization. using System.Runtime.Serialization.Formatters.Binary; using System.Xml.Serialization; namespace Framework { public static class IGUtilities { public static string Serialization(this T obj) ...

This is similar to Docker-machine or minikube which are used to learn Docker and Kubernetes. It will run a virtual machine containing everything you need to test openshift-origin. Here is the documentation from openshift-origin and how to install it on any OS here I'll write doc for Debian-lik...

When a remote session is created via the New-PSsession cmdlet, the PSSession persists until the current PowerShell session ends. Meaning that, by default, the PSSession and all associated resources will continue to be used until the current PowerShell session ends. Multiple active PSSessions can b...

File exists: Sub FileExists() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") If fso.FileExists("D:\test.txt") = True Then MsgBox "The file is exists." Else MsgBox "The file isn't exist...

Copy: Sub CopyFile() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") fso.CopyFile "c:\Documents and Settings\Makro.txt", "c:\Documents and Settings\Macros\" End Sub Move: Sub MoveFile() Dim fso as Scri...

Create: Sub CreateFolder() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") fso.CreateFolder "c:\Documents and Settings\NewFolder" End Sub Copy: Sub CopyFolder() Dim fso as Scripting.FileSystemObject Set fso...

Get file name: Sub GetFileName() Dim fso as Scripting.FileSystemObject Set fso = CreateObject("Scripting.FileSystemObject") MsgBox fso.GetFileName("c:\Documents and Settings\Makro.txt") End Sub Result: Makro.txt Get base name: Sub GetBaseName() Dim fso ...

ChainMap is new in version 3.3 Returns a new ChainMap object given a number of maps. This object groups multiple dicts or other mappings together to create a single, updateable view. ChainMaps are useful managing nested contexts and overlays. An example in the python world is found in the implemen...

videoView.setVideoURI(Uri.parse("http://example.com/examplevideo.mp4")); videoView.requestFocus(); videoView.setOnCompletionListener(new MediaPlayer.OnCompletionListener() { @Override public void onCompletion(MediaPlayer mediaPlayer) { } }); videoView.setO...

Detailed instructions on getting drupal-8 set up or installed.

The first version of HTTP that came into existence is 0.9, often referred to as "HTTP As Implemented." A common description of 0.9 is "a subsect of the full HTTP [i.e. 1.0] protocol." However, this greatly fails to illustrate the disparity in capabilities between 0.9 and 1.0. Ne...

The first major distinction is between the dynamically generated directories which will be used for hosting and source directories. The source directories will have a config file or folder depending on the amount of configuration you may have . This includes the environment configuration and busi...

This will take about 30 minutes. We will be setting Ruby on Rails Development Environment on Ubuntu 16.10 Yakkety Yak. You'll want to download the latest Desktop version here: http://releases.ubuntu.com/17.04/ Open up your terminal using Ctrl + Alt + T. Installing Ruby The First step is to ins...

To let RestTemplate understand generic of returned content we need to define result type reference. org.springframework.core.ParameterizedTypeReference has been introduced since 3.2 Wrapper<Model> response = restClient.exchange(url, HttpMethod.GET, ...

F() expressions can be used to execute arithmetic operations (+, -, * etc.) among model fields, in order to define an algebraic lookup/connection between them. Let model be: class MyModel(models.Model): int_1 = models.IntegerField() int_2 = models.IntegerField() Now lets assum...

This example demonstrates the use of GET, POST, PUT and DELETE HTTP Methods in doing CRUD operations on a REST resource I am using the below software, frameworks and tools: Jersey 2.25.1 JDK 1.7.x (Java 7) Eclipse IDE Kepler Apache Maven 3.3.9 Apache Tomcat 7.x Please follow the below ste...

To have a look of the different functionalities of the hybris platform, you can use the install recipes. For this, just download the HYBRISCOMMXXXX_X-XXXXXXXX.ZIP and extract it to you local device. Than go through the following steps: The <recipe_names> you can find under the folder \hybris\...

The first standalone R script Standalone R scripts are not executed by the program R (R.exe under Windows), but by a program called Rscript (Rscript.exe), which is included in your R installation by default. To hint at this fact, standalone R scripts start with a special line called Shebang line, ...