Tutorial by Examples: u

Download the files from our.umbraco.org/download and unzip them in a folder. Set up web server hosting the folder you chose. Although IIS is a requirement for production sites, it runs fine for development in IIS Express. Set up file permissions for the folder. For development server it is okey ...

Check for updates to the Nuget package manager. In Visual Studio: Tools > Extensions and Updates > Updates > Visual Studio Gallery. Install if availalbe Create a new web application with template "ASP.NET Web Application with an Empty template" on .NET Framework 4.5.1 Open the...

Either you just want to test out Umbraco CMS, or host your site in a cloud service, you could sign up for a free trial at umbraco.com/cloud. The site you develop in the cloud service could be downloaded for local development or your own hosting later.

The Memory Model is difficult to understand, and difficult to apply. It is useful if you need to reason about the correctness of multi-threaded code, but you do not want to have to do this reasoning for every multi-threaded application that you write. If you adopt the following principals when wri...

Use an ensure clause if there is code you always want to execute. def divide(x, y) begin z = x/y return z rescue ZeroDivisionError puts "Don't divide by zero!" rescue TypeError puts "Division only works on numbers!" return nil rescue => e ...

select sysdate from dual

select :start_value + level -1 n from dual connect by level <= :end_value - :start_value + 1

You can customize parsing rules using different options in WITH clause: BULK INSERT People FROM 'f:\orders\people.csv' WITH ( CODEPAGE = '65001', FIELDTERMINATOR =',', ROWTERMINATOR ='\n' ); In this example, CODEPAGE specifies that a source file in UTF-8 f...

BULK INSERT command can be used to import file into SQL Server: BULK INSERT People FROM 'f:\orders\people.csv' BULK INSERT command will map columns in files with columns in target table.

You can read content of file using OPENROWSET(BULK) function and store content in some table: INSERT INTO myTable(content) SELECT BulkColumn FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document; SINGLE_BLOB option will read entire content from a file as single cell. ...

Yu can define format of the file that will be imported using FORMATFILE option: INSERT INTO mytable SELECT a.* FROM OPENROWSET(BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a; The format file, format_file.fmt, describes the columns in values.txt: 9.0 2 1 SQ...

You can use OPENROWSET to read content of file and pass it to some other function that will parse results. The following example shows hot to read entire content of JSON file using OPENROWSET(BULK) and then provide BulkColumn to OPENJSON function that will parse JSON and return columns: SELECT boo...

There’s a tempting existing field called profile that is added by default when a new user registers. This field was historically intended to be used as a scratch pad for user-specific data - maybe their image avatar, name, intro text, etc. Because of this, the profile field on every user is automati...

Following setup ensures that testing framework (PHPUnit) uses :memory: database. config/database.php 'connections' => [ 'sqlite_testing' => [ 'driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '', ], . . . ./phpun...

As with everything in Windows Azure, You have to have a Windows Azure account and an Azure Subscription. After you have both, go to https://portal.azure.com. From here, you can add new resources to your Azure subscription. Click New on the left menu.A new blade will be added to the right of you...

PERFORM some-paragraph

There are three ways to quote something using a Julia function: julia> QuoteNode(:x) :(:x) julia> Meta.quot(:x) :(:x) julia> Expr(:quote, :x) :(:x) What does "quoting" mean, and what is it good for? Quoting allows us to protect expressions from being interpreted as sp...

This is a contrived sample. It sorts records based on an ALPHABET that has upper and lower case characters together, with A and a swapped compared to the other letters. This was done on purpose to demonstrate the possibilities. The SORT algorithm reader retrieves records using RELEASE in the INPU...

This is a seedwork sample. The SORT OUTPUT PROCEDURE could manipulate the sorted records before they are returned to the write portion of the internal COBOL sort algorithm. In this case, no transformation is done, work-rec is directly moved to out-rec. GCobol >>SOURCE FORMAT IS FIXED ...

To separate API logic from the component, we are creating the API client as a separate class. This example class makes a request to Wikipedia API to get random wiki articles. import { Http, Response } from '@angular/http'; import { Injectable } from '@angular/core'; import { Observabl...