Tutorial by Examples: d

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

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

Register at apex.world today! apex.world is the center of everything APEX - jobs, tutorials, Twitter feeds, newsletters, plug-ins, and more!

samtools idxstats thing.bam

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

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

Big Data, in its most basic form, can be described as the umbrella term metricized by different aspects of data. These different aspects are Volume(Huge quantity of Data), Velocity(Greater dataflow speeds), Variety(Structured, Unstructured and Semi-structured Data) and Veracity(Making right decis...

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

A Cmd cannot be reused after calling its Run, Output or CombinedOutput methods Running a command twice will not work: cmd := exec.Command("xte", "key XF86AudioPlay") _ := cmd.Run() // Play audio key press // .. do something else err := cmd.Run() // Pause audio key press,...

To view all elements in the index change the print options that “sparsifies” the display of the MultiIndex. pd.set_option('display.multi_sparse', False) df.groupby(['A','B']).mean() # Output: # C # A B # a 1 107 # a 2 102 # a 3 115 # b 5 92 # b 8 98 # c 2 87 # c 4 104 #...

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

Big data is a term for data sets that are so large or complex that traditional data processing applications are inadequate to deal with them. Challenges include analysis, capture, data curation, search, sharing, storage, transfer, visualization, querying, updating and information privacy. A general...

<!DOCTYPE html> <html lang="en-EN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="csrf-param" content="_csrf"> <me...

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

Pass an upper limit as an argument to the rand() function. Input: my $upper_limit = 100; my $random = rand($upper_limit); print $random . "\n"; Output: A random floating-point number, like... 45.8733038119139