Tutorial by Examples: o

Swift 2.3 let url = NSURL(string: "http://google.com/lastPath") let lastPath = url?.lastPathComponent Swift 3.0 let url = URL(string: "http://google.com/lastPath") let lastPath = url?.lastPathComponent

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"

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

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

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