Tutorial by Examples: p

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

1st or 2nd line in source code (to have literals in the code utf8-encoded): # -*- coding: utf-8 -*- Connection: db = MySQLdb.connect(host=DB_HOST, user=DB_USER, passwd=DB_PASS, db=DB_NAME, charset="utf8mb4", use_unicode=True) For web pages, one of these: <meta charset=...

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

In php.ini (this is the default after PHP 5.6): default_charset UTF-8 When building a web page: header('Content-type: text/plain; charset=UTF-8'); When connecting to MySQL: (for mysql:) Do not use the mysql_* API! (for mysqli:) $mysqli_obj->set_charset('utf8mb4'); (for PDO:) $db...

A basic implementation for singly-linked-list in java - that can add integer values to the end of the list, remove the first value encountered value from list, return an array of values at a given instant and determine whether a given value is present in the list. Node.java package com.example.so....

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 VARYING TALLY FROM 1 BY 1 UNTIL TALLY > 5 DISPLAY TALLY END-PERFORM

PERFORM some-paragraph

READ data-file

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

You may want to read a DataFrame from a CSV (Comma separated values) file or maybe even from a TSV or WSV (tabs and whitespace separated files). If your file has the right extension, you can use the readtable function to read in the dataframe: readtable("dataset.CSV") But what if your ...

Assuming you have a model that looks like the following, we will get up an running with a simple barebones read-only API driven by Django REST Framework ("DRF"). models.py class FeedItem(models.Model): title = models.CharField(max_length=100, blank=True) url = models.URLField(b...

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

Since defining all of the authorization logic in the AuthServiceProvider could become cumbersome in large applications, Laravel allows you to split your authorization logic into "Policy" classes. Policies are plain PHP classes that group authorization logic based on the resource they autho...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin Put_Line ("Hello from My_Task"); end; begin Put_Line ("Hello from Main"); end; Result The order of Put_Line can vary. Hello from My_Task Hello from ...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task"); end loop; end; begin Put_Line ("Hello from Main"); end; Result The order of Put...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task"); end loop; end; begin for I in 1 .. 4 loop Put_Line ("Hello from Main"); e...