Dynamic SQL enables us to generate and run SQL statements at run time. Dynamic SQL is needed when our SQL statements contains identifier that may change at different compile times.
Simple Example of dynamic SQL:
CREATE PROC sp_dynamicSQL
@table_name NVARCHAR(20),
@col_name NVARCHAR(2...
Trees are a sub-type of the more general node-edge graph data structure.
To be a tree, a graph must satisfy two requirements:
It is acyclic. It contains no cycles (or "loops").
It is connected. For any given node in the graph, every node is reachable. All nodes are reachable throug...
TestSchedulers allows you to control time and execution of Observables instead of having to do busy waits, joining threads or anything to manipulate system time. This is VERY important if you want to write unit tests that are predictable, consistent and fast. Because you are manipulating time, the...
A module is a collection of related reusable functions (or cmdlets) that can easily be distributed to other PowerShell users and used in multiple scripts or directly in the console. A module is usually saved in it's own directory and consists of:
One or more code files with the .psm1 file extensi...
super keyword performs important role in three places
Constructor Level
Method Level
Variable Level
Constructor Level
super keyword is used to call parent class constructor. This constructor can be default constructor or parameterized constructor.
Default constructor : super();
Pa...
Create a font extension using the IDE. See the iReport or Jaspersoft Studio documentation for details. The font extension can also be created manually.
What are font extensions?
Using a textElement you can specify a font (if not specified default font SansSerif is used)
<textElement>
&...
GET your REST data and store in a PowerShell object:
$Post = Invoke-RestMethod -Uri "http://jsonplaceholder.typicode.com/posts/1"
Modify your data:
$Post.title = "New Title"
PUT the REST data back
$Json = $Post | ConvertTo-Json
Invoke-RestMethod -Method Put -Uri "h...
These are the available editions of SQL Server, as told by the Editions Matrix:
Express: Entry-level free database. Includes core-RDBMS functionality. Limited to 10G of disk size. Ideal for development and testing.
Standard Edition: Standard Licensed edition. Includes core functionality and Busi...
WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. Alongside, PhpMyAdmin allows you to manage easily your databases.
WampServer is available for free (under GPML license) in two distinct versions : 32 and 64 bits. Wa...
First of all you need to have IIS (Internet Information Services) installed and running on your machine; IIS isn't available by default, you have to add the characteristic from Control Panel -> Programs -> Windows Characteristics.
Download the PHP version you like from http://windows.php.ne...
The find function
First let's take a look at the string.find function in general:
The function string.find (s, substr [, init [, plain]]) returns the start and end index of a substring if found, and nil otherwise, starting at the index init if it is provided (defaults to 1).
("Hello, I am a ...
This uses the SwiftyDropbox library to upload a file from a NSFileHandle to the Dropbox account using upload sessions, handling every error case:
import UIKit
import SwiftyDropbox
class ViewController: UIViewController {
// filled in later in doUpload:
var fileHandle : NSFileHandle?...
Sometimes we have another editor somewhere else instead of TinyMCE (Wordpress Default Editor). That happen when we are creating our own Theme, Plugin or something specific; and we need to write and manipulate a type of post and save it into our WP Database.
So, if you are on that situation, you can...
SELECT 1,22,44
UNION
SELECT 2,33,55
SELECT 1,22,44
UNION
SELECT 2,33,55
UNION
SELECT 2,33,55
The result is the same as above.
use UNION ALL
when
SELECT 1,22,44
UNION
SELECT 2,33,55
UNION ALL
SELECT 2,33,55
Ionic has some CSS components where you can use Ionicons as a default which have preset styling. The range class in the item <div> will apply correct styling to both the input and the icons inside it. Here's an example of a range slider.
<div class="item range">
<i class...
You should make sure that module DBI has been installed on your pc, then follow the bellow steps:
use DBI module in your perl script
use DBI;
Declare some primary parameters
my $driver = "MyDriver";
my $database = "DB_name";
my $dsn = "DBI:$driver:dbname=$datab...
Type below command:
instmodsh
It'll show you the guild as below:
Available commands are:
l - List all installed modules
m <module> - Select a module
q - Quit the program
cmd?
Then type l to list all the installed modules, you can also use command m &l...
Example of Receiver Operating Characteristic (ROC) metric to evaluate classifier output quality.
ROC curves typically feature true positive rate on the Y axis, and false positive rate on the X axis. This means that the top left corner of the plot is the “ideal” point - a false positive rate of zero...
h = 1.0 / n;
#pragma omp parallel for private(x) shared(n, h) reduction(+:area)
for (i = 1; i <= n; i++)
{
x = h * (i - 0.5);
area += (4.0 / (1.0 + x*x));
}
pi = h * area;
In this example, each threads execute a subset of the iteration count. Each thread has its local private copy ...
h = 1.0 / n;
#pragma omp parallel for private(x) shared(n, h, area)
for (i = 1; i <= n; i++)
{
x = h * (i - 0.5);
#pragma omp critical
{
area += (4.0 / (1.0 + x*x));
}
}
pi = h * area;
In this example, each threads execute a subset of the iteration count and they accumul...
