Tutorial by Examples: g

MERGE INTO targetTable t USING sourceTable s ON t.PKID = s.PKID WHEN MATCHED AND NOT EXISTS ( SELECT s.ColumnA, s.ColumnB, s.ColumnC INTERSECT SELECT t.ColumnA, t.ColumnB, s.ColumnC ) THEN UPDATE SET t.Colum...

$ printf '%(%F)T\n' 2016-08-17

Lets create a simple transformation to convert a CSV into an XML file. Our Transformation has to do the following: Read the CSV file Build the greetings message Save the greetings in the XML file Create a Transformation: Here's how to start the Transformation: To the left of the works...

Sometimes when working with linear regression we need to check for non-linearity in the data. One way to do this is to fit a polynomial model and check whether it fits the data better than a linear model. There are other reasons, such as theoretical, that indicate to fit a quadratic or higher order ...

C# inherits from C and C++ the usage of the symbol -> as a means of accessing the members of an instance through a typed pointer. Consider the following struct: struct Vector2 { public int X; public int Y; } This is an example of the usage of -> to access its members: Vector2...

The criteria that a type must satisfy in order to support pointers (see Remarks) cannot be expressed in terms of generic constraints. Therefore, any attempt to declare a pointer to a type provided through a generic type parameter will fail. void P<T>(T obj) where T : struct { T* p...

So, you have completed installation it's time now to Run you program with it. Netbeans has created a shortcut to your desktop, "Double click" that to open the IDE. To Create a new project 1. Click this button OR Goto: files >> New Project then this window will popup Select...

Digital hardware is built from two types of hardware primitives: Combinatorial gates (inverters, and, or, xor, 1-bit full adders, 1-bit multiplexers...) These logic gates perform a simple boolean computation on their inputs and produce an output. Each time one of their inputs changes, they st...

This example is the second of a series of 3. If you didn't yet, please read the Block diagram example first. With a block diagram that complies with the 10 rules (see the Block diagram example), the VHDL coding becomes straightforward: the large surrounding rectangle becomes the VHDL entity,...

This example is directly derived from John Cooley’s design contest at SNUG’95 (Synopsys Users Group meeting). The contest was intended to oppose VHDL and Verilog designers on the same design problem. What John had in mind was probably to determine what language was the most efficient. The result...

This implementation of IDatabaseInitializer drops and recreates the database if the model changes automatically. Usage: public class MyContext : DbContext { public MyContext() { Database.SetInitializer(new DropCreateDatabaseIfModelChanges<MyContext>()); } }

An implementation of IDatabaseInitializer that will use Code First Migrations to update the database to the latest version. To use this initializer you have to use DbMigrationsConfiguration type too. Usage: public class MyContext : DbContext { public MyContext() { Database.SetInitial...

SignedObject is a class for the purpose of creating authentic runtime objects whose integrity cannot be compromised without being detected. More specifically, a SignedObject contains another Serializable object, the (to-be-)signed object and its signature. //Create a key KeyPairGenerator keyGen...

Block strings can be used to hold formatted or indentation-sensitive text (or, if you just don't feel like escaping quotes and apostrophes). The indentation level that begins the block is maintained throughout, so you can keep it all aligned with the body of your code. html = """ ...

Multiline strings are allowed in CoffeeScript. Lines are joined by a single space unless they end with a backslash. Indentation is ignored. mobyDick = "Call me Ishmael. Some years ago -- never mind how long precisely -- having little or no money in my purse, and nothing particular to ...

While the if ()... else statement allows to define only one (default) behaviour which occurs when the condition within the if () is not met, chaining two or more if () ... else statements allow to define a couple more behaviours before going to the last else branch acting as a "default", i...

Plenty has been written about Python's GIL. It can sometimes cause confusion when dealing with multi-threaded (not to be confused with multiprocess) applications. Here's an example: import math from threading import Thread def calc_fact(num): math.factorial(num) num = 600000 t = Threa...

Use the following piece of code to set the badge number from within your application (suppose someNumber has been declared before): Objective-C [UIApplication sharedApplication].applicationIconBadgeNumber = someNumber; Swift UIApplication.shared.applicationIconBadgeNumber = someNumber In order ...

module.exports.routes = { 'GET /blog/:year/:month/:day/:posttitle/': 'BlogController.showPost', 'GET /blog/:year/:month/:day/': 'BlogController.showDayArchive', 'GET /blog/:year/:month/': 'BlogController.showMonthArchive', 'GET /blog/:year/': 'BlogController.showYearArchive', }; The ...

There's an installation guide for running a JIRA Server under Windows or Linux / Mac ( see Installing JIRA applications) For local testing there's an SDK, which starts a JIRA test instance and can be used to develop JIRA Plugins (see Set up the Atlassian Plugin SDK and Build a Project)