Tutorial by Examples: l

EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE

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

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

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

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

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

$ jobs [1] Running sleep 500 & (wd: ~) [2]- Running sleep 600 & (wd: ~) [3]+ Running ./Fritzing & First field shows the job ids. The + and - sign that follows the job id for two jobs denote the default job and next candidate def...

Since a Vimscript file is a collection of Command mode actions, the user needs to specify that the desired actions should be executed in normal mode. Therefore executing a normal mode command like i, a, d etc. in Vimscript is done by prepending the command with normal: Going to the bottom of the f...

If you are running a command that returns hundreds of lines, but your interest is just on the lines that contains the word <word>, you should definitely use grep! For example try running: ifconfig -a Check the output, that could be only a few lines or quite long, if you have a server with ...

C# Suppose you want to test that when you hover over an element, a drop list is displayed. You may want to check the contents of this list, or perhaps select an option from the list. First create an Action, to hover over the element (e.g. my element has link text "Admin"): Actions mouse...

To target Internet Explorer 6 and Internet Explorer 7, start your properties with *: .hide-on-ie6-and-ie7 { *display : none; // This line is processed only on IE6 and IE7 } Non-alphanumeric prefixes (other than hyphens and underscores) are ignored in IE6 and IE7, so this hack works for any...

To target Internet Explorer 8, wrap your selectors inside @media \0 screen { }: @media \0 screen { .hide-on-ie8 { display : none; } } Everything between @media \0 screen { } is processed only by I