Tutorial by Examples

Place Picker is a really simple UI widget provided by Places API. It provides a built-in map, current location, nearby places, search abilities and autocomplete. This is a sample usage of Place Picker UI widget. private static int PLACE_PICKER_REQUEST = 1; private TextView txtPlaceName; @Ove...

You can get the current location and local places of user by using the Google Places API. Ar first, you should call the PlaceDetectionApi.getCurrentPlace() method in order to retrieve local business or other places. This method returns a PlaceLikelihoodBuffer object which contains a list of PlaceLi...

To rename remote, use command git remote rename The git remote rename command takes two arguments: An existing remote name, for example : origin A new name for the remote, for example : destination Get existing remote name git remote # origin Check existing remote with URL git remote -...

Informally, a monad is a container of elements, notated as F[_], packed with 2 functions: flatMap (to transform this container) and unit (to create this container). Common library examples include List[T], Set[T] and Option[T]. Formal definition Monad M is a parametric type M[T] with two operatio...

Returns a sub string starting with the left most char of a string and up to the maximum length specified. Parameters: character expression. The character expression can be of any data type that can be implicitly converted to varchar or nvarchar, except for text or ntext max length. An integer n...

Returns a sub string that is the right most part of the string, with the specified max length. Parameters: character expression. The character expression can be of any data type that can be implicitly converted to varchar or nvarchar, except for text or ntext max length. An integer number betwe...

Returns a substring that starts with the char that's in the specified start index and the specified max length. Parameters: Character expression. The character expression can be of any data type that can be implicitly converted to varchar or nvarchar, except for text or ntext. Start index. A nu...

Returns an int value representing the ASCII code of the leftmost character of a string. SELECT ASCII('t') -- Returns 116 SELECT ASCII('T') -- Returns 84 SELECT ASCII('This') -- Returns 84 If the string is Unicode and the leftmost character is not ASCII but representable in the current collatio...

Returns the start index of a the first occurrence of string expression inside another string expression. Parameters list: String to find (up to 8000 chars) String to search (any valid character data type and length, including binary) (Optional) index to start. A number of type int or big int. ...

Returns a char represented by an int ASCII code. SELECT CHAR(116) -- Returns 't' SELECT CHAR(84) -- Returns 'T' This can be used to introduce new line/line feed CHAR(10), carriage returns CHAR(13), etc. See AsciiTable.com for reference. If the argument value is not between 0 and 255, the CHAR...

Returns the number of characters of a string. Note: the LEN function ignores trailing spaces: SELECT LEN('My string'), -- returns 9 LEN('My string '), -- returns 9 LEN(' My string') -- returns 12 If the length including trailing spaces is desired there are several techniques...

SQL Server 2012 Returns a string that is the result of two or more strings joined together. CONCAT accepts two or more arguments. SELECT CONCAT('This', ' is', ' my', ' string') -- returns 'This is my string' Note: Unlike concatenating strings using the string concatenation operator (+), when ...

Returns a character expression (varchar or nvarchar) after converting all uppercase characters to lowercase. Parameters: Character expression. Any expression of character or binary data that can be implicitly converted to varchar. SELECT LOWER('This IS my STRING') -- Returns 'this is my strin...

Returns a character expression (varchar or nvarchar) after converting all lowercase characters to uppercase. Parameters: Character expression. Any expression of character or binary data that can be implicitly converted to varchar. SELECT UPPER('This IS my STRING') -- Returns 'THIS IS MY STRIN...

Returns a character expression (varchar or nvarchar) after removing all leading white spaces, i.e., white spaces from the left through to the first non-white space character. Parameters: character expression. Any expression of character or binary data that can be implicitly converted to varcher,...

Returns a character expression (varchar or nvarchar) after removing all trailing white spaces, i.e., spaces from the right end of the string up until the first non-white space character to the left. Parameters: character expression. Any expression of character or binary data that can be implicit...

Returns the integer value representing the Unicode value of the first character of the input expression. Parameters: Unicode character expression. Any valid nchar or nvarchar expression. SELECT UNICODE(N'Ɛ') -- Returns 400 DECLARE @Unicode nvarchar(11) = N'Ɛ is a char' SELECT UNICODE(@Uni...

Returns the Unicode character(s) (nchar(1) or nvarchar(2)) corresponding to the integer argument it receives, as defined by the Unicode standard. Parameters: integer expression. Any integer expression that is a positive number between 0 and 65535, or if the collation of the database supports sup...

The switch statement is a control statement that selects a switch section to execute from a list of candidates. A switch statement includes one or more switch sections. Each switch section contains one or more case labels followed by one or more statements. If no case label contains a matching value...

An interface contains the signatures of methods, properties and events. The derived classes defines the members as the interface contains only the declaration of the members. An interface is declared using the interface keyword. interface IProduct { decimal Price { get; } } class Product...