Tutorial by Topics

={item1,item2} ={item2,item2;item3,item4} ={{item1;item2},{item3,item4;item5,item6}} ParameterDetailsitemNIt could be a value, a cell reference, a range reference or a function Overview An array of literals is written between curly brackets. Separators depends on the spreadsheet's reg...

Table valued parameters (TVP for short) are parameters passed to a stored procedure or function that contains data that is table structured. Using table valued parameters requires creating a user defined table type for the parameter being used. Tabled valued parameters are readonly parameters. ...

requires java.xml; requires public java.xml; # exposes module to dependents for use exports com.example.foo; # dependents can use public types in this package exports com.example.foo.impl to com.example.bar; # restrict usage to a module The use of modules is encouraged but not required, ...

Powershell naming system has quite strict rules of naming cmdlets (Verb-Noun template; see [topic not yet created] for more information). But it is not really convenient to write Get-ChildItems every time you want to list files in directory interactively. Therefore Powershell enables using shortc...

new WeakMap([iterable]); weakmap.get(key); weakmap.set(key, value); weakmap.has(key); weakmap.delete(key); For uses of WeakMap, see What are the actual uses of ES6 WeakMap?.

The Unity Container (Unity) is a lightweight, extensible dependency injection container. It facilitates building loosely coupled applications and provides developers with the following advantages: Simplified object creation, especially for hierarchical object structures and dependencies. [https://...

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. A system-versioned temp...

target_compile_features(target PRIVATE|PUBLIC|INTERFACE feature1 [feature2 ...])

This service allows users to send emails with complete control over the content of the email. Unlike GmailApp, MailApp's sole purpose is sending email. MailApp cannot access a user's Gmail inbox. Changes to scripts written using GmailApp are more likely to trigger a re-authorization request from a ...

PL/pgSQL is PostgreSQL's built-in programming language for writing functions which run within the database itself, known as stored procedures in other databases. It extends SQL with loops, conditionals, and return types. Though its syntax may be strange to many developers it is much faster than an...

If you want to offer suggestions to the user when they type in an editable text field, you can use an AutoCompleteTextView. It provides suggestions automatically when the user is typing. The list of suggestions is displayed in a drop down menu from which the user can select one to replace the cont...

Cursor cursor_name Is your_select_statement Cursor cursor_name(param TYPE) Is your_select_statement_using_param FOR x in (your_select_statement) LOOP ... Declared Cursors are difficult to use, and you should prefer FOR loops in most cases. What's very interesting in cursors compared to si...

This section provides an overview of what windows-10-universal is, and why a developer might want to use it. It should also mention any large subjects within windows-10-universal, and link out to the related topics. Since the Documentation for windows-10-universal is new, you may need to create ...