Tutorial by Examples: u

The $User variable gives you access to all the standard and custom fields on the User object for the currently logged in user. You are logged in as a user from {!$User.CompanyName}.

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

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

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

Detailed instructions on getting Robot Framework set up or installed. Robot framework is a generic test automation framework.This is implemented using Python and is supported on Python 2 and Python 3 Jython (JVM) and IronPython (.NET) and PyPy. For Acceptance testing Acceptance test-driven dev...

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

This is the image of project structure in Android studio: This is the image of project structure of nativescript project: As you see they are same. so we can write java code in nativescript as we write in android studio. We want to Add Toast to the default app of nativescript. after creating...

We want to add Toast to nativescript default app. import {Component} from "@angular/core"; let application = require("application"); declare var android:any; @Component({ selector: "my-app", templateUrl: "app.component.html", }) export clas...

Download the latest version of ANTLR and extract it to a folder. You can use also Maven, Gradle, or other build tool to depend on its runtime (the classes the generated grammars use): org.antlr:antlr4-runtime. In order to automatically -as part of the build process- generate the parser in a maven ...

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

A "Connection timed out" error occurs when the remote system does not respond to the client's attempt to open a TCP/IP connection. The most common causes include: A firewall is blocking the connection attempt on the port that you are using: The firewall could be on the client-side, ...

It is convenient to set custom conditional preprocessing at project level when some actions need to be skipped lets say for tests. Go to Solution Explorer -> Click Right Mouse on project you want to set variable to -> Properties -> Build -> In General find field Conditional compilation ...

A grouped VIEW is based on a query with a GROUP BY clause. Since each of the groups may have more than one row in the base from which it was built, these are necessarily read-only VIEWs. Such VIEWs usually have one or more aggregate functions and they are used for reporting purposes. They are also h...

VIEWs based on a UNION or UNION ALL operation are read-only because there is no single way to map a change onto just one row in one of the base tables. The UNION operator will remove duplicate rows from the results. Both the UNION and UNION ALL operators hide which table the rows came from. Such VIE...

Ordinary Least Squares is a method for finding the linear combination of features that best fits the observed outcome in the following sense. If the vector of outcomes to be predicted is y, and the explanatory variables form the matrix X, then OLS will find the vector β solving minβ|y^ - y|22, w...

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

If you want to extract a folder, but you want to exclude one or several folders during the extraction, you can use the --exclude option. tar -cf archive.tar ./my-folder/ --exclude="my-folder/sub1" --exclude="my-folder/sub3" With this folder tree : my-folder/ sub1/ su...