Tutorial by Topics: le

You can use hierarchical queries to retrieve data based on a natural hierarchical relationship between rows in a table

Example of how to copy existing table structure with/without data CREATE TABLE schemaName.table AS (SELECT columns FROM schemaName.table) WITH DATA

Using SSIS to extract data from a CSV file and insert into a SQL Server table

There is a built in easy way to read files in binary within VBA, however it has a restriction of 2GB (2,147,483,647 bytes - max of Long data type). As technology evolves, this 2GB limit is easily breached. e.g. an ISO image of Operating System install DVD disc. Microsoft does provide a way to overco...

Progress ABL is statically typed. The variables need to be declared and the datatype cannot be changed during run time. DEFINE VARIABLE i AS INT64 INITIAL -200 NO-UNDO. //A 64-bit integer initialized to -200 DEFINE VARIABLE l AS LOGICAL NO-UNDO. //A logical variable named l DEFINE ...

Fitting a line (or other function) to a set of data points.

Xamarin.Android application lifecycle is the same as normal Android app. When talking about lifecycle we need to talk about: Application lifecycle, Activity lifecycle and Fragment lifecycle. In the below I'll try to provide a good description and way of using them. I obtained this documentation fr...

Unlike many languages, Kotlin distinguishes between mutable and immutable collections (lists, sets, maps, etc). Precise control over exactly when collections can be edited is useful for eliminating bugs, and for designing good APIs. listOf, mapOf and setOf returns read-only objects that you ca...

The Sequential model is a linear stack of layers.

This section shows basic code for reading, sub-setting and writing external data files using pandas.

Small, simple csv files can be built using just a text editor. Reading and writing them, or otherwise processing their contents is done more efficiently using the products available for one's language or systems of choice.

The Ada standard library provides for I/O of traditional files of text or binary data, as well as I/O of streamed files. Files of binary data will be sequences of values of a type, while stream files can be sequences of values of possibly different types. To read and write elements of different ...

This is an explanation of a common pattern and generally considered best practice that you may see in AngularJS code.

Google appscript runs well as a stand alone platform and in the addon format for Google docs, sheets and forms. However, there are times when a client browser may need to call to a Google app to perform some action. Therefore, Google introduced client side requests to Google apps-scripts. To solve ...

First part of an introduction to stores and the folders they contain. Contains macros to display (1) the names of accessible stores and (2) the names of accessible stores and the top level folders within them.

This article is to introduce a simple and professional practice to use Entity Framework. Simple: because it only needs one class (with one interface) Professional: because it applies SOLID architecture principles I don't wish to talk more.... let's enjoy it!