Tutorial by Examples: s

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

SELECT is an Open-SQL-statement for reading data from one or several database tables into data objects. Selecting All Records * This returns all records into internal table lt_mara. SELECT * FROM mara INTO lt_mara. Selecting Single Record * This returns single record if tabl...

[[UITabBar appearance] setTintColor:[UIColor whiteColor]]; [[UITabBar appearance] setBarTintColor:[UIColor tabBarBackgroundColor]]; [[UITabBar appearance] setBackgroundColor:[UIColor tabBarInactiveColor]]; [[UINavigationBar appearance] setBarTintColor:[UIColor appBlueColor]]; [[UINavigationBar a...

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

Create a new text file named HelloWorld.java and paste this code in it: import org.eclipse.swt.*; import org.eclipse.swt.layout.*; import org.eclipse.swt.widgets.*; public class HelloWorld { public static void main(String[] args) { final Display display = new Display(); ...

We can use rseq :: Strategy a to force an argument to Weak Head Normal Form: f1 :: [Int] f1 = [1..100000000] f2 :: [Int] f2 = [1..200000000] main = runEval $ do a <- rpar (f1) -- this'll take a while... b <- rpar (f2) -- this'll take a while and then some... rseq a return ...

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

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

Parameters can be specified in path property of route configuration 'use strict'; const Hapi = require('hapi'); // Create a server with a host and port const server = new Hapi.Server(); server.connection({ host: 'localhost', port: 8000 }); // Add a route path with url par...

TextBox txt = (TextBox)FindControl(yourtxt_Id);

Creating arrays explicitly using ArrayNew() Declare an array with the ArrayNew function. Specify the number of dimensions as an argument. ArrayNew(dimension) creates an array of 1–3 dimensions. ColdFusion arrays expand dynamically as data is added. ArrayNew() returns an array. History Intr...

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