Tutorial by Examples: a

You can create a secondary replica of database with the same name on another Azure SQL Server, making the local database primary, and begins asynchronously replicating data from the primary to the new secondary. ALTER DATABASE <<mydb>> ADD SECONDARY ON SERVER <<secondaryserver&gt...

You can put your azure SQL Database in SQL elastic pool: CREATE DATABASE wwi ( SERVICE_OBJECTIVE = ELASTIC_POOL ( name = mypool1 ) ) You can create copy of an existing database and place it in some elastic pool: CREATE DATABASE wwi AS COPY OF myserver.WideWorldImporters ( SERVICE_OBJECTIV...

An instantiation error is thrown if an argument is not sufficiently instantiated. Critically, an instantiation error cannot be replaced by silent failure: Failing in such cases would mean that there is no solution, whereas an instantiation error means that an instance of the argument may participat...

Prolog features exceptions, which are part of the Prolog ISO standard. An exception can be thrown with throw/1, and caught with catch/3. The ISO standard defines many cases in which errors must or may be thrown. The standardized exceptions are all of the form error(E,_), where E indicates the erro...

The predicate setup_call_cleanup/3, which is currently being considered for inclusion in the Prolog ISO standard and provided by an increasing number of implementations, lets us ensure that resources are correctly freed after an exception is thrown. A typical invocation is: setup_call_cleanup(open...

A type error occurs if an argument is not of the expected type. Examples of types are: integer atom list. If the predicate is of the expected type, but outside the expected domain, then a domain error is raised. For example, a domain error is admissible if an integer between 0 and 15 is exp...

Detailed instructions on getting raphael set up or installed.

gem 'any gem',git: 'any repo',branch: 'specific branch of that repo',ref: 'reference no.' ref specifies individual commit. branch specifies the git branch to pull from.

CLR procedures are not enabled by default. You need to run the following queries to enable CLR: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'clr enabled', 1; GO RECONFIGURE; GO In addition, if some CLR module need external access, you should set TRUSTWORTHY pr...

Procedures, functions, triggers, and types written in .Net languages are stored in .dll files. Once you create .dll file containing CLR procedures you should import it into SQL Server: CREATE ASSEMBLY MyLibrary FROM 'C:\lib\MyStoredProcedures.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS PERM...

If you have created .Net function, compiled it into .dll, and imported it into SQL server as an assembly, you can create user-defined function that references function in that assembly: CREATE FUNCTION dbo.TextCompress(@input nvarchar(max)) RETURNS varbinary(max) AS EXTERNAL NAME MyLibrary.[Nam...

If you have create .Net class that represents some user-defined type, compiled it into .dll, and imported it into SQL server as an assembly, you can create user-defined function that references this class: CREATE TYPE dbo.Point EXTERNAL NAME MyLibrary.[Name.Space.Point] You need to specify name...

If you have created .Net method in some class, compiled it into .dll, and imported it into SQL server as an assembly, you can create user-defined stored procedure that references method in that assembly: CREATE PROCEDURE dbo.DoSomethng(@input nvarchar(max)) AS EXTERNAL NAME MyLibrary.[Name.Space....

Consider a base class Vehicle and its derived class Car as follows: #import <Foundation/Foundation.h> @interface Vehicle : NSObject { NSString *vehicleName; NSInteger vehicleModelNo; } - (id)initWithName:(NSString *)name andModel:(NSInteger)modelno; - (void)print; @end ...

Given a text txt and a pattern pat, the objective of this program will be to print all the occurance of pat in txt. Examples: Input: txt[] = "THIS IS A TEST TEXT" pat[] = "TEST" output: Pattern found at index 10 Input: txt[] = "AABAACAADAABAAABAA" ...

// 1.0 function beforeLoad(type, form, request) { nlapiLogExecution("DEBUG", "Before Load", "type=" + type); } // 2.0 /** * @NApiVersion 2.x * @NScriptType UserEventScript * @NModuleScope SameAccount */ define(["N/log"], function (log) { ...

public void Screenshot() throws Throwable{ final byte[] screenshot = ((TakesScreenshot) driver).getScreenshotAs(OutputType.BYTES); scenario.embed(screenshot, "image/png"); // ... and embed it in the report. Thread.sleep(1000); } Alternately public static void captureSc...

It's not the best way of iterating through the pixels; however, it's better than cv::Mat::at<T>. Let's assume you have a color image in your folder and you want to iterate each pixels of this image and erase green and red channels(Note that this is an example, you can do this in more optimize...

Range.CurrentRegion is a rectangular range area surrounded by empty cells. Blank cells with formulas such as ="" or ' are not considered blank (even by the ISBLANK Excel function). Dim rng As Range, lastCell As Range Set rng = Range("C3").CurrentRegion ' or Set rng = Shee...

#include <iostream> #include <map> #include <string> using namespace std; class A { public: map<string, string> * mapOfStrings; public: A() { mapOfStrings = new map<string, string>(); } void insertEntry(string const & key, st...