Tutorial by Examples

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

Date FormatSQL StatementSample OutputYY-MM-DDSELECT RIGHT(CONVERT(VARCHAR(10), SYSDATETIME(), 20), 8) AS [YY-MM-DD]SELECT REPLACE(CONVERT(VARCHAR(8), SYSDATETIME(), 11), '/', '-') AS [YY-MM-DD]11-06-08YYYY-MM-DDSELECT CONVERT(VARCHAR(10), SYSDATETIME(), 120) AS [YYYY-MM-DD]SELECT REPLACE(CONVERT(VAR...

These are the available editions of SQL Server, as told by the Editions Matrix: Express: Entry-level free database. Includes core-RDBMS functionality. Limited to 10G of disk size. Ideal for development and testing. Standard Edition: Standard Licensed edition. Includes core functionality and Busi...

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

Returns average 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 AVG(MarksObtained) From Marksheet The average function doesn't consider rows with NULL value in the field used ...

Returns the largest value 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 MAX(MarksObtained) From Marksheet

Returns the smallest value 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 MIN(MarksObtained) From Marksheet

Returns the total number of 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 COUNT(MarksObtained) From Marksheet The count function doesn't consider rows with NULL value in the field used...

SELECT Row_Number() OVER(ORDER BY UserName) As RowID, UserFirstName, UserLastName FROM Users From which it will yield a result set with a RowID field which you can use to page between. SELECT * FROM ( SELECT Row_Number() OVER(ORDER BY UserName) As RowID, UserFirstName, UserLastName ...

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

We can use the [] to create an empty Array in Julia. The simplest example would be: A = [] # 0-element Array{Any,1} Arrays of type Any will generally not perform as well as those with a specified type. Thus, for instance, we can use: B = Float64[] ## 0-element Array{Float64,1} C = Array{Flo...

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