Tutorial by Examples: n

Selecting specified number of records

The SQL 2008 standard defines the FETCH FIRST clause to limit the number of records returned. SELECT Id, ProductName, UnitPrice, Package FROM Product ORDER BY UnitPrice DESC FETCH FIRST 10 ROWS ONLY This standard is only supported in recent versions of some RDMSs. Vendor-specific non-stand...

SQL • SELECT

Empty message is not printed

When NSLog is asked to print empty string, it omits the log completely. NSString *name = @""; NSLog(@"%@", name); // Resolves to @"" The above code will print nothing. It is a good practice to prefix logs with labels: NSString *name = @""; NSLog(@&quo...

Objective-C Language • Logging

Comprehensions involving tuples

The for clause of a list comprehension can specify more than one variable: [x + y for x, y in [(1, 2), (3, 4), (5, 6)]] # Out: [3, 7, 11] [x + y for x, y in zip([1, 3, 5], [2, 4, 6])] # Out: [3, 7, 11] This is just like regular for loops: for x, y in [(1,2), (3,4), (5,6)]: print(x+y) ...

Python Language • List comprehensions

Using Jackson Object Mapper

Pojo Model public class Model { private String firstName; private String lastName; private int age; /* Getters and setters not shown for brevity */ } Example: String to Object Model outputObject = objectMapper.readValue( "{\"firstName\":\"J...

Java Language • JSON in Java

Implicit Call Syntax

ProcedureName ProcedureName argument1, argument2 Call a procedure by its name without any parentheses. Edge case The Call keyword is only required in one edge case: Call DoSomething : DoSomethingElse DoSomething and DoSomethingElse are procedures being called. If the Call keyword was rem...

VBA • Procedure Calls

Return Values

To retrieve the result of a procedure call (e.g. Function or Property Get procedures), put the call on the right-hand side of an assignment: result = ProcedureName result = ProcedureName(argument1, argument2) Parentheses must be present if there are parameters. If the procedure has no parameter...

VBA • Procedure Calls

This is confusing. Why not just always use parentheses?

Parentheses are used to enclose the arguments of function calls. Using them for procedure calls can cause unexpected problems. Because they can introduce bugs, both at run-time by passing a possibly unintended value to the procedure, and at compile-time by simply being invalid syntax. Run-time Re...

VBA • Procedure Calls

Explicit Call Syntax

Call ProcedureName Call ProcedureName(argument1, argument2) The explicit call syntax requires the Call keyword and parentheses around the argument list; parentheses are redundant if there are no parameters. This syntax was made obsolete when the more modern implicit call syntax was added to VB. ...

VBA • Procedure Calls

Lexicographical comparison

Two std::strings can be compared lexicographically using the operators ==, !=, <, <=, >, and >=: std::string str1 = "Foo"; std::string str2 = "Bar"; assert(!(str1 < str2)); assert(str > str2); assert(!(str1 <= str2)); assert(str1 >= str2); assert...

C++ • std::string

Attach object to another existing object (association)

It's possible to attach an object to an existing object as if there was a new property. This is called association and allows one to extend existing objects. It can be used to provide storage when adding a property via a class extension or otherwise add additional information to an existing object. ...

Objective-C Language • Low-level Runtime Environment

Augmenting methods using Method Swizzling

The Objective-C runtime allows you to change the implementation of a method at runtime. This is called method swizzling and is often used to exchange the implementations of two methods. For example, if the methods foo and bar are exchanged, sending the message foo will now execute the implementation...

Objective-C Language • Low-level Runtime Environment

Creating NSArray instances

NSArray *array1 = [NSArray arrayWithObjects:@"one", @"two", @"three", nil]; NSArray *array2 = @[@"one", @"two", @"three"];

Objective-C Language • NSArray

Embedding external SVG files in HTML

You can use the <img> or <object> elements to embed external SVG elements. Setting the height and width is optional but is highly recommended. Using the image element <img src="attention.svg" width="50" height="50"> Using <img> does not allo...

HTML • SVG

Inline SVG

SVG can be written directly into a HTML document. Inline SVG can be styled and manipulated using CSS and JavaScript. <body> <svg class="attention" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 0 1000 1000&qu...

HTML • SVG

Embedding SVG using CSS

You can add external SVG files using the background-image property, just as you would do with any other image. HTML: <div class="attention"></div> CSS: .attention { background-image: url(attention.svg); background-size: 100% 100%; width: 50px; height: ...

HTML • SVG

Splitting

You can split a string into an array of parts, divided by a separator character. NSString * yourString = @"Stack,Exchange,Network"; NSArray * yourWords = [yourString componentsSeparatedByString:@","]; // Output: @[@"Stack", @"Exchange", @"Network&quot...

Objective-C Language • NSString

Searching for a Substring

To search if a String contains a substring, do the following: NSString *myString = @"This is for checking substrings"; NSString *subString = @"checking"; BOOL doesContainSubstring = [myString containsString:subString]; // YES If targeting iOS 7 or OS X 10.9 (or earlier)...

Objective-C Language • NSString

Work with Arrays, Not With Ranges

Office Blog - Excel VBA Performance Coding Best Practices Often, best performance is achieved by avoiding the use of Range as much as possible. In this example we read in an entire Range object into an array, square each number in the array, and then return the array back to the Range. This accesse...

excel-vba • VBA Best Practices

Variable Names

Variables hold data. Name them after what they're used for, not after their data type or scope, using a noun. If you feel compelled to number your variables (e.g. thing1, thing2, thing3), then consider using an appropriate data structure instead (e.g. an array, a Collection, or a Dictionary). Names...

VBA • Naming Conventions

Procedure Names

Procedures do something. Name them after what they're doing, using a verb. If accurately naming a procedure is not possible, likely the procedure is doing too many things and needs to be broken down into smaller, more specialized procedures. Some common VBA naming conventions go thus: For all Pr...

VBA • Naming Conventions