Tutorial by Examples: at

The FOR XML PATH can be used for concatenating values into string. The example below concatenates values into a CSV string: DECLARE @DataSource TABLE ( [rowID] TINYINT ,[FirstName] NVARCHAR(32) ); INSERT INTO @DataSource ([rowID], [FirstName]) VALUES (1, 'Alex') ,(2, 'Peter') ...

Windows PowerShell is included with the Windows Management Framework. Installation and Setup are not required on modern versions of Windows. Updates to PowerShell can be accomplished by installing a newer version of the Windows Management Framework. Other Platforms "Beta" version of P...

The easiest way to set up NumPy on Mac is with pip pip install numpy Installation using Conda. Conda available for Windows, Mac, and Linux Install Conda. There are two ways to install Conda, either with Anaconda (Full package, include numpy) or Miniconda (only Conda,Python, and the package...

Sometimes you want to iterate over a range of dates from a start date to some end date. You can do it using datetime library and timedelta object: import datetime # The size of each step in days day_delta = datetime.timedelta(days=1) start_date = datetime.date.today() end_date = start_date ...

$float = 0.123; For historical reasons "double" is returned by gettype() in case of a float, and not simply "float" Floats are floating point numbers, which allow more output precision than plain integers. Floats and integers can be used together due to PHP's loose casti...

Option 1: Leiningen Requires JDK 6 or newer. The easiest way to get started with Clojure is to download and install Leiningen, the de facto standard tool to manage Clojure projects, then run lein repl to open a REPL. Linux curl https://raw.githubusercontent.com/technomancy/leiningen/stable/bin/l...

While using scaffolding is a fast and easy if you are new to Rails or you are creating a new application, later it can be useful just to do it on your own ato avoid the need to go through the scaffold-generated code to slim it down (remove unused parts, etc.). Creating a model can be as simple as c...

Ruby on Rails provides a model generator you can use to create ActiveRecord models. Simply use rails generate model and provide the model name. $ rails g model user In addition to the model file in app/models, the generator will also create: the Test in test/models/user_test.rb the Fixtures ...

This example requires the headers <algorithm>, <locale>, and <utility>. C++11 To trim a sequence or string means to remove all leading and trailing elements (or characters) matching a certain predicate. We first trim the trailing elements, because it doesn't involve moving any el...

Getting setup with Spring Boot for the first time is quite fast thanks to the hard work of the Spring Community. Prerequisites: Java installed Java IDE Recommended not required (Intellij, Eclipse, Netbeans, etc.) You don't need to have Maven and/or Gradle installed. The projects generate...

Sometimes you have to check for a condition and set the value of a variable. For ex. String name; if (A > B) { name = "Billy"; } else { name = "Jimmy"; } This can be easily written in one line as String name = A > B ? "Billy" : "Jimmy&quo...

Windows Verify that you have the correct JDK. You can check it by opening command prompt (press windows key and write cmd). In the command prompt type javac -version, this will show the current version of JDK installed on your matching or an error* if Java is missing. If the JDK is not availabl...

Following is an implementation that demonstrates how an object can be serialized into its corresponding JSON string. class Test { private int idx; private String name; public int getIdx() { return idx; } public void setIdx(int idx) { this.idx = idx; ...

A custom component that takes the type of a component as input and creates an instance of that component type inside itself. When the input is updated, the previously added dynamic component is removed and the new one added instead. @Component({ selector: 'dcl-wrapper', template: `<div #...

Simple: NSString *newString = @"My String"; From multiple strings: NSString *stringOne = @"Hello"; NSString *stringTwo = @"world"; NSString *newString = [NSString stringWithFormat:@"My message: %@ %@", stringOne, stringTwo]; Usi...

Ruby provides several ways to create a String object. The most common way is using single or double quotes to create a "string literal": s1 = 'Hello' s2 = "Hello" The main difference is that double-quoted string literals are a little bit more flexible as they support interpo...

Concatenate strings with the + operator: s1 = "Hello" s2 = " " s3 = "World" puts s1 + s2 + s3 # => Hello World s = s1 + s2 + s3 puts s # => Hello World Or with the << operator: s = 'Hello' s << ' ' s << 'World' puts s # => ...

The double-quoted delimiter " and %Q sequence supports string interpolation using #{ruby_expression}: puts "Now is #{Time.now}" # Now is Now is 2016-07-21 12:47:45 +0200 puts %Q(Now is #{Time.now}) # Now is Now is 2016-07-21 12:47:45 +0200

By default, all the required libraries for build ASP.NET applications are included during the installation of Visual Studio. If a newer version of ASP.NET is released that was not included with Visual Studio, you can download the appropriate SDK library from Microsoft, which will include all the nec...

Few people have issue regarding error message not displaying if existing value is being entered in textbox. So, For Example I'm not allowing user to enter existing email. signup.php (Page where you wanted to sign up new user without existing email id) Remove use yii\bootstrap\ActiveForm; (if p...