Tutorial by Examples: build

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

Over the course of time B-Tree indexes may become fragmented because of updating/deleting/inserting data. In SQLServer terminology we can have internal (index page which is half empty ) and external (logical page order doesn't correspond physical order). Rebuilding index is very similar to dropping...

You can create and configure build types in the module-level build.gradle file inside the android {} block. android { ... defaultConfig {...} buildTypes { release { minifyEnabled true proguardFiles getDefaultProguar...

R has a number of build in constants. The following constants are available: LETTERS: the 26 upper-case letters of the Roman alphabet letters: the 26 lower-case letters of the Roman alphabet month.abb: the three-letter abbreviations for the English month names month.name: the English names fo...

Suppose you have complex code that creates and returns a list by starting with a blank list and repeatedly appending to it: def create(): result = [] # logic here... result.append(value) # possibly in several places # more logic... return result # possibly in several places...

:mak[e][!] [arguments] will start the program referred to by the makeprg option. By default, makeprg is set to "make," but can be configured to invoke any appropriate program. All [arguments] (can be several) are passed to makeprg just as if it had been invoked with :!{makeprg} [arguments...

Use pub build when you’re ready to deploy your web app. When you run pub build, it generates the assets for the current package and all of its dependencies, putting them into new directory named build. To use pub build, just run it in your package’s root directory. For example: $ cd ~/dart/hellowo...

You can use gradle to have BuildConfig constants and res values on a per flavor basis. Just add the value to the flavor you want to support. android { defaultConfig { resValue "string", "app_name", "Full App" buildConfigField "boolean",...

One favored approach to deploying to a server is to use Git or GitHub. This basically involves logging into your server, moving to the directory you want to run your app from, then cloning your files directly from GitHub. You then build your app on the server. This approach ensures that platform spe...

Before you begin tuning your Gradle build for performance, you should establish a baseline and figure out which portions of the build are taking the most time. To do this, you can profile your build by adding the --profile argument to your Gradle command: gradle --profile ./gradlew --profile Af...

The Builder pattern allows you to create an instance of a class with many optional variables in an easy to read way. Consider the following code: public class Computer { public GraphicsCard graphicsCard; public Monitor[] monitors; public Processor processor; public Memory[] r...

$ jekyll build # The current site folder will be built into the ./_site directory $ jekyll build --destination /var/www/ # The current site folder will be generated into /var/www/ $ jekyll build --watch # The current site folder will be built into the ./_site directory and will be kept up t...

In this example our project name is "helloworld" which was created with stack new helloworld simple First we have to build the project with stack build and then we can run it with stack exec helloworld-exe

Directives can be used to build reusable components. Here is an example of a "user box" component: userBox.js angular.module('simpleDirective', []).directive('userBox', function() { return { scope: { username: '=username', reputation: '=reputation' }, ...

A typical use case for SpriteKit is where the SKView fills the whole screen. To do this in Xcode's Interface Builder, first create a normal ViewController, then select the contained view and change its Class from UIView to SKView: Within the code for the View Controller, in the viewDidLoad metho...

The following example utilizes the tm text mining package to scrape and mine text data from the web to build word clouds with symbolic shading and ordering. require(RWeka) require(tau) require(tm) require(tm.plugin.webmining) require(wordcloud) # Scrape Google Finance -----------------------...

Concatenating strings using a StringBuilder can offer performance advantages over simple string concatenation using +. This is due to the way memory is allocated. Strings are reallocated with each concatenation, StringBuilders allocate memory in blocks only reallocating when the current block is e...

Drag a gesture recognizer from the object library onto your view. Control drag from the gesture in the Document Outline to your View Controller code in order to make an Outlet and an Action. Notes This example comes from this fuller sample project demonstrating gesture recognizers.

An SKView does not need to fill the whole screen and can share space with other UI controls. You can even have more than one SKView displayed at once if you wish. To create a smaller SKView amongst other controls with Interface Builder, first create a normal ViewController, then drag and drop a new...

Elm Reactor is the essential tool for prototyping your application. Please note, that you will not be able to compile Main.elm with Elm Reactor, if you are using Http.App.programWithFlags or Ports Running elm-reactor in a projects directory will start a web server with a project explorer, that all...