Tutorial by Topics: q

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

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

SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2; SELECT column_name(s) FROM table1 UNION ALL SELECT column_name(s) FROM table2; SELECT column_name(s) FROM table1 WHERE col_name="XYZ" UNION ALL SELECT column_name(s) FROM table2 WHERE col_name="XYZ&qu...

hg qnew -m "My commit message" myPatch hg qpop hg qpush hg qrefresh -m "My new commit message" hg qapplied hg qseries hg qfinish hg qdelete myPatch hg qfold myPatch hg qqueue --list hg qqueue --create myNewQueue hg qqueue --delete myNewQueue

You either need to be in the path where SQLCMD.exe exists or add it to your PATH environment variable.

Not everything that starts with a backslash is an escape sequence. Many characters are just not useful to escape sequences, and will simply cause a preceding backslash to be ignored. "\H\e\l\l\o" === "Hello" // true On the other hand, some characters like "u" and...

official documentation: Prepared Statement Object

mysql [OPTIONS] [database_name] ParameterDescription-D --database=namename of the database--delimiter=strset the statement delimiter. The default one is ';'-e --execute='command'execute command-h --host=namehostname to connect to-p --password=namepassword Note: there is no space between -p a...

#Requires -Version <N>[.<n>] #Requires –PSSnapin <PSSnapin-Name> [-Version <N>[.<n>]] #Requires -Modules { <Module-Name> | <Hashtable> } #Requires –ShellId <ShellId> #Requires -RunAsAdministrator #requires statement can be placed on any li...

Sqoop incremental import comes into picture because of a phenomenon called CDC i.e. Change Data Capture. Now what is CDC? CDC is a design pattern that captures individual data changes instead of dealing with the entire data. Instead of dumping our entire database, using CDC, we could capture ju...

Node.js uses streams to handle incoming data. Quoting from the docs, A stream is an abstract interface for working with streaming data in Node.js. The stream module provides a base API that makes it easy to build objects that implement the stream interface. To handle in request body of a PO...

Moq is a mocking library for .Net. It allows interactions with dependencies to be simulated and verified in order to facilitate unit testing. Release notes for different version of Moq can be found here.

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