Tutorial by Examples: f

DocumentDB supports rich queries against JSON documents stored in each collection. With a LINQ query IQueryable<Family> familyQuery = this.client.CreateDocumentQuery<Family>( UriFactory.CreateDocumentCollectionUri(databaseName, collectionName), queryOptions) .Where(f => f....

In some cases it may not suffice to know whether more that one methods were called. The calling order of methods is also important. In such case you may use InOrder class of Mockito to verify the order of methods. SomeClass mock1 = Mockito.mock(SomeClass.class); otherClass mock2 = Mockito.mock(Oth...

Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write. Entity Framework allows you to create a model by writing cod...

Goal: <FruitBasket xmlns="http://www.fruitauthority.fake"> <Fruit> <FruitName>Banana</FruitName> <FruitColor>Yellow</FruitColor> </Fruit> <Fruit> <FruitName>Apple</FruitName> <FruitColor>Red<...

You can select the last day of month. SELECT (date_trunc('MONTH', ('201608'||'01')::date) + INTERVAL '1 MONTH - 1 day')::DATE; 201608 is replaceable with a variable.

Any attempt to modify a const object results in undefined behavior. This applies to const variables, members of const objects, and class members declared const. (However, a mutable member of a const object is not const.) Such an attempt can be made through const_cast: const int x = 123; const_cas...

The change the definition of a db column, the query below can be used for example, if we have this db schema users ( firstname varchar(20), lastname varchar(20), age char(2) ) To change the type of age column from char to int, we use the query below: ALTER TABLE users CHANGE age...

In Unix, files and directories beginning with a period usually contain settings for a specific program/a series of programs. Dot files are usually hidden from the user, so you would need to run ls -a to see them. An example of a dot file is .bash_history, which contains the latest executed commands...

You will need a domain name from a registrar. In the gh-pages branch of your project repository, or the main branch of your username.github.io repository, create a CNAME file with the contents www.yourdomain.com - the canonical domain. At your registrar's domain configuration page, point your doma...

Exec sp_configure 'backup compression default',1 GO RECONFIGURE;

sp_configure 'fill factor', 100; GO RECONFIGURE; The server must be restarted before the change can take effect.

EXEC sp_configure "number of checkpoint tasks", 4

Like most of the other programming languages, T-SQL also supports IF..ELSE statements. For example in the example below 1 = 1 is the expression, which evaluates to True and the control enters the BEGIN..END block and the Print statement prints the string 'One is equal to One' IF ( 1 = 1) --<-...

We can use multiple IF statement to check multiple expressions totally independent from each other. In the example below, each IF statement's expression is evaluated and if it is true the code inside the BEGIN...END block is executed. In this particular example, the First and Third expressions are ...

In a single IF..ELSE statement, if the expression evaluates to True in the IF statement the control enters the first BEGIN..END block and only the code inside that block gets executed , Else block is simply ignored. On the other hand if the expression evaluates to False the ELSE BEGIN..END block ge...

If we have Multiple IF...ELSE IF statements but we also want also want to execute some piece of code if none of expressions are evaluated to True , then we can simple add a final ELSE block which only gets executed if none of the IF or ELSE IF expressions are evaluated to true. In the example below...

More often than not we need to check multiple expressions and take specific actions based on those expressions. This situation is handled using multiple IF...ELSE IF statements. In this example all the expressions are evaluated from top to bottom. As soon as an expression evaluates to true, the cod...

You can apply formats within a procedure, e.g. to change the groupings within a proc summary or proc freq. Grouping SAS dates data example2 ; do Date = '01JUN2016'dt to '31AUG2016'dt ; Days = 1 ; output ; end ; run ; /* Summarise by year & month */ proc summary data=exampl...

A "Connection Refused" error will occur if your client sends a connection request to a remote server host, and the remote host responds to say that it refuses to accept the request. The "Connection Refused" error essentially means that the computer is not accepting connections to...

In order to write tests using Selenium Webdriver and Java as programming language, you will need to download JAR files of Selenium Webdriver from the Selenium website. There are multiple ways to setup a Java project for the Selenium webdriver, one of the easiest from all of them is using Maven. Mav...