Tutorial by Examples: on

JSON_MODIFY function uses JSON text as input parameter, and modifies a value on the specified path using third argument: declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car","Price":34.99}' set @json = JSON_MODIFY(@json, '$.Price', 39.99) print @json -...

JSON_MODIFY has 'append' mode that appends value into array. declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car","Tags":["toy","game"]}' set @json = JSON_MODIFY(@json, 'append $.Tags', 'sales') print @json -- Output: {"Id&quot...

JSON_MODIFY function enables you to insert JSON objects into JSON text: declare @json nvarchar(4000) = N'{"Id":1,"Name":"Toy Car"}' set @json = JSON_MODIFY(@json, '$.Price', JSON_QUERY('{"Min":34.99,"Recommended":45.49}'))...

You can generate JSON object using standard SELECT query with FOR JSON clause and insert it into JSON text as third parameter: declare @json nvarchar(4000) = N'{"Id":17,"Name":"WWI"}' set @json = JSON_MODIFY(@json, '$.tables', (select name fr...

You can generate JSON object using standard SELECT query with FOR JSON clause and WITHOUT_ARRAY_WRAPPER option, and insert it into JSON text as a third parameter: declare @json nvarchar(4000) = N'{"Id":17,"Name":"WWI"}' set @json = JSON_MODIFY(@json, '$.table', ...

1. Bagged Decision Trees Bagging performs best with algorithms that have high variance. A popular example are decision trees, often constructed without pruning. In the example below see an example of using the BaggingClassifier with the Classification and Regression Trees algorithm (DecisionTreeCl...

Samtools can be used to convert between sam and bam: -b indicates that the input file will be in BAM format -S indicates that the stdout should be in SAM format samtools view -sB thing.bam > thing.sam And to convert between sam and bam: samtools view thing.sam > thing.bam samtools ...

Parallelism in Haskell can be expressed using the Eval Monad from Control.Parallel.Strategies, using the rpar and rseq functions (among others). f1 :: [Int] f1 = [1..100000000] f2 :: [Int] f2 = [1..200000000] main = runEval $ do a <- rpar (f1) -- this'll take a while... b <- rpa...

[UIView animateWithDuration:1.0 animations:^{ someView.alpha = 0; otherView.alpha = 1; } completion:^(BOOL finished) { [someView removeFromSuperview]; }]; The carat “^” character defines a block. For example, ^{ … } is a block. More specifically, it is a blo...

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:ReleaseBundle.properties</value> </list> </bean>

try: metadata = metadata['properties'] except KeyError: pass

class CompileError(Exception): pass

Add Firebase to Your Android Project Add Firebase to your app To add Firebase to your app you'll need a Firebase project and a Firebase configuration file for your app. Create a Firebase project in the Firebase console, if you don't already have one. If you already have an existing Google proje...

TextBox txt = (TextBox)FindControl(yourtxt_Id);

The header ctype.h is a part of the standard C library. It provides functions for classifying and converting characters. All of these functions take one parameter, an int that must be either EOF or representable as an unsigned char. The names of the classifying functions are prefixed with 'is'. Ea...

Character modifying functions include converting characters to upper or lower case characters, converting numbers to formatted numbers, performing character manipulation, etc. The lower(char) function converts the given character parameter to be lower-cased characters. SELECT customer_id, lower(cu...

Before Auto Layout, you always had to tell buttons and other controls how big they should be, either by setting their frame or bounds properties or by resizing them in Interface Builder. But it turns out that most controls are perfectly capable of determining how much space they need, based on their...

When browser navigates to a dynamic page (most commonly AJAX-based web application), the elements on the page can take different time to load, and furthermore: some elements will only load in response to some user actions. In such cases direct retrieval of an element may fail: # Don't do this: may ...

Here we will create collection for losses of Neural Network's computational graph. First create a computational graph like so: with tf.variable_scope("Layer"): W = tf.get_variable("weights", [m, k], initializer=tf.zeros_initializer([m, k], dtype=tf.float32)) ...

Detailed instructions on getting logstash set up or installed.