Tutorial by Examples: s

GET your REST data and store in a PowerShell object: $Post = Invoke-RestMethod -Uri "http://jsonplaceholder.typicode.com/posts/1" Modify your data: $Post.title = "New Title" PUT the REST data back $Json = $Post | ConvertTo-Json Invoke-RestMethod -Method Put -Uri "h...

GET your REST data and store in a PowerShell object: $Users = Invoke-RestMethod -Uri "http://jsonplaceholder.typicode.com/users" Modify many items in your data: $Users[0].name = "John Smith" $Users[0].email = "[email protected]" $Users[1].name = "Jane S...

Identify the item that is to be deleted and delete it: Invoke-RestMethod -Method Delete -Uri "http://jsonplaceholder.typicode.com/posts/1"

# Define a class class TypeName { # Property with validate set [ValidateSet("val1", "Val2")] [string] $P1 # Static property static [hashtable] $P2 # Hidden property does not show as result of Get-Member hidden [int] $P3 # Constructor Ty...

Returns sum of numeric values in a given column. We have table as shown in figure that will be used to perform different aggregate functions. The table name is Marksheet. Select SUM(MarksObtained) From Marksheet The sum function doesn't consider rows with NULL value in the field used as param...

Julia's Char type represents a Unicode scalar value, which only in some cases corresponds to what humans perceive as a "character". For instance, one representation of the character é, as in résumé, is actually a combination of two Unicode scalar values: julia> collect("é&quot...

In Julia, you can have an Array that holds other Array type objects. Consider the following examples of initializing various types of Arrays: A = Array{Float64}(10,10) # A single Array, dimensions 10 by 10, of Float64 type objects B = Array{Array}(10,10,10) # A 10 by 10 by 10 Array. Each ele...

There are numerous ways to convert numeric types to strings in Julia: julia> a = 123 123 julia> string(a) "123" julia> println(a) 123 The string() function can also take more arguments: julia> string(a, "b") "123b" You can also insert (aka ...

In Julia, as in many other languages, it is possible to interpolate by inserting values defined by variables into strings. For a simple example: n = 2 julia> MyString = "there are $n ducks" "there are 2 ducks" We can use other types than numeric, e.g. Result = false j...

If you have void F1(MyType1 x) { // do something } void F1(MyType2 x) { // do something else } and for some reason you need to call the first overload of F1 but with x = null, then doing simply F1(null); will not compile as the call is ambiguous. To counter this you can do F1...

Detailed instructions on getting wso2is set up or installed.

Expressions are a specific type of object in Julia. You can think of an expression as representing a piece of Julia code that has not yet been evaluated (i.e. executed). There are then specific functions and operations, like eval() which will evaluate the expression. For instance, we could write ...

There are a number of different methods that can be used to create the same type of expression. The expressions intro mentioned the :() syntax. Perhaps the best place to start, however is with strings. This helps to reveal some of the fundamental similarities between expressions and strings in Ju...

As mentioned in the Intro to Expressions expressions are a specific type of object in Julia. As such, they have fields. The two most used fields of an expression are its head and its args. For instance, consider the expression MyExpr3 = Expr(:(=), :x, 2) discussed in Creating Expressions. We...

Creating Expressions mentions that expressions are closely related to strings. As such, the principles of interpolation within strings are also relevant for Expressions. For instance, in basic string interpolation, we can have something like: n = 2 julia> MyString = "there are $n ducks&q...

There are a number of useful web resources that can help further your knowledge of expressions in Julia. These include: Julia Docs - Metaprogramming Wikibooks - Julia Metaprogramming Julia’s macros, expressions, etc. for and by the confused, by Gray Calhoun Month of Julia - Metaprogramming, b...

CREATE SCHEMA dvr AUTHORIZATION Owner CREATE TABLE sat_Sales (source int, cost int, partid int) GRANT SELECT ON SCHEMA :: dvr TO User1 DENY SELECT ON SCHEMA :: dvr to User 2 GO

ALTER SCHEMA dvr TRANSFER dbo.tbl_Staging; GO This would transfer the tbl_Staging table from the dbo schema to the dvr schema

DROP SCHEMA dvr

Schema refers to a specific database tables and how they are related to each other. It provides an organisational blueprint of how the database is constructed. Additional benefits of implementing database schemas is that schemas can be used as a method restricting / granting access to specific table...