Tutorial by Topics

DECLARE @VariableName DataType [ = Value ] ; SET @VariableName = Value ;

Setup Download and install Atmel Studio 7 from here. Purchase a debugger. You can get by with a ISP programmer, but if you want debugging capabilities, which is one of the big advantages of using Atmel Studio, you will want a debugger. I recommend the Atmel ICE, as it provides debugging ca...

JSON_VALUE(expression , path) -- extract a scalar value from a JSON string. JSON_QUERY( expression [ , path ] ) -- Extracts an object or an array from a JSON string. OPENJSON( jsonExpression [ , path ] ) -- table-value function that parses JSON text and returns objects and properties in JSON as ...

The core.match library implements a pattern match compilation algorithm that uses the notion of "necessity" from lazy pattern matching.

Bit shift operations are not portable across all processor architectures, different processors can have different bit-widths. In other words, if you wrote int a = ~0; int b = a << 1; This value would be different on a 64 bit machine vs. on a 32 bit machine, or from an x86 based processo...

Each thread will have its own last error code. The Windows API will set the last error code on the calling thread. You should always call the GetLastError function immediately after checking a Windows API function's return value. The majority of Windows API functions set the last error code whe...

counter-set: [ <counter-name> <integer>? ]+ | none counter-reset: [ <counter-name> <integer>? ]+ | none counter-increment: [ <counter-name> <integer>? ]+ | none counter(<counter-name> [, <counter-style> ]?) counters(<counter-...

In HTTP, status codes are a machine-readable mechanism indicating the result of a previously issued request. From RFC 7231, sec. 6: "The status-code element is a three-digit integer code giving the result of the attempt to understand and satisfy the request." The formal grammar allows cod...

gettext(message) ngettext(singular, plural, number) ugettext(message) ungettext(singular, plural, number) pgettext(context, message) npgettext(context, singular, plural, number) gettext_lazy(message) ngettext_lazy(singular, plural, number=None) ugettext_lazy(message) ungettext_lazy(singu...

PLSQL procedure is a group of SQL statements stored on the server for reuse. It increases the performance because the SQL statements do not have to be recompiled every time it is executed. Stored procedures are useful when same code is required by multiple applications. Having stored procedures eli...

Kruskal's Algorithm is a greedy algorithm used to find Minimum Spanning Tree (MST) of a graph. A minimum spanning tree is a tree which connects all the vertices of the graph and has the minimum total edge weight. Kruskal's algorithm does so by repeatedly picking out edges with minimum weight (whi...

The DOM, or Document Object Model, is the API used by web browsers and other applications to access the contents of an HTML document. The DOM represents the structure as a tree, nodes can contain child-nodes, nodes with no children are said leaf nodes. With it, one can manipulate the structure a...

Sitecore offers two ways to access items that the context user doesn't have permissions to access. The preferred way is to use the UserSwitcher class to temporarily change the user that will be used to access the item. The reason that this is preferred is because you can still have permissions in ...

(id)JSONObjectWithData:(NSData *)data options:(NSJSONReadingOptions)opt error:(NSError * _Nullable *)error OperatorDescriptiondataA data object containing JSON dataoptOptions for reading the JSON data and creating the Foundation objects.errorIf an error occurs, upon return contains an NSEr...

Type qualifiers are the keywords which describe additional semantics about a type. They are an integral part of type signatures. They can appear both at the topmost level of a declaration (directly affecting the identifier) or at sub-levels (relevant to pointers only, affecting the pointed-to valu...

Haxe is an open source toolkit that is capable of compiling to many different target languages and platforms. It consists of: the Haxe programming language - a modern, high-level, and strictly typed programming language the Haxe standard library - a collection of general purpose, system, and ...