Tutorial by Examples: i

There are several packages which can run Processing sketches in the Atom editor. These instructions use the Script package. There are also available packages for syntax highlighting and autocomplete, which are required for Script to identify Processing filetypes. Install the Script plugin. Either b...

Advanced functions behave the in the same way as cmdlets. The PowerShell ISE includes two skeletons of advanced functions. Access these via the menu, edit, code snippets, or by Ctrl+J. (As of PS 3.0, later versions may differ) Key things that advanced functions include are, built-in, customiz...

In this example, we will look at a method for returning the last non-empty column in a row. This method will work regardless of empty regions within the data set. However caution should be used if merged cells are involved, as the End method will be "stopped" against a merged region, ret...

First of all, Merged Cells are there only to improve the look of your sheets. So it is literally the last thing that you should do, once your sheet and workbook are totally functional! Where is the data in a Merged Range? When you merge a Range, you'll only display one block. The data will be ...

For example: You are going to migrate an existing column from non-required to required. In this case you might need to fill some default values in your migration for rows where the altered fields are actually NULL. In case the default value is simple (e.g. "0") you might use a default or d...

Pigeonhole Sort is a sorting algorithm that is suitable for sorting lists of elements where the number of elements (n) and the number of possible key values (N) are approximately the same. It requires O(n + Range) time where n is number of elements in input array and ‘Range’ is number of possible va...

Relational Algebra is not a full-blown SQL language, but rather a way to gain theoretical understanding of relational processing. As such it shouldn't make references to physical entities such as tables, records and fields; it should make references to abstract constructs such as relations, tuples ...

import Foundation class CookiesSingleton { static let instance : CookiesSingleton = CookiesSingleton() static var enableDebug = true func loadCookies() { if let cookiesDetails = NSUserDefaults.standardUserDefaults().objectForKey("customeWebsite") { for (keys,_) i...

Radix Sort is lower bound comparison based algorithm. It is a non-comparative integer sorting algorithm that sorts data with integer keys by grouping keys by individual digits which share some significant position and value. Radix sort is a linear time sorting algorithm that sort in O(n+k) time whe...

One easy algorithm to implement as a recursive function is factorial. ;;Compute the factorial for any n >= 0. Precondition: n >= 0, n is an integer. (defun factorial (n) (cond ((= n 0) 1) ;; Special case, 0! = 1 ((= n 1) 1) ;; Base case, 1! = 1 (t ...

If you're creating an image, decoding an image, or resizing an image to fit the large notification image area, you can get the correct pixel dimensions like so: Resources resources = context.getResources(); int width = resources.getDimensionPixelSize(android.R.dimen.notification_large_icon_width)...

DBCC commands enable user to maintain space in database, clean caches, shrink databases and tables. Examples are: DBCC DROPCLEANBUFFERS Removes all clean buffers from the buffer pool, and columnstore objects from the columnstore object pool. DBCC FREEPROCCACHE -- or DBCC FREEPROCCACHE (0x06...

DBCC commands enable user to validate state of database. ALTER TABLE Table1 WITH NOCHECK ADD CONSTRAINT chkTab1 CHECK (Col1 > 100); GO DBCC CHECKCONSTRAINTS(Table1); --OR DBCC CHECKCONSTRAINTS ('Table1.chkTable1'); Check constraint is added with nocheck options, so it will not be ...

DBCC commands can show information about database objects. DBCC PROCCACHE Displays information in a table format about the procedure cache. DBCC OUTPUTBUFFER ( session_id [ , request_id ]) Returns the current output buffer in hexadecimal and ASCII format for the specified session_id (and o...

When called without arguments, Node.js starts a REPL (Read-Eval-Print-Loop) also known as the “Node shell”. At a command prompt type node. $ node > At the Node shell prompt > type "Hello World!" $ node > "Hello World!" 'Hello World!'

ghci> :set -XOverloadedStrings ghci> import Data.Text as T isInfixOf :: Text -> Text -> Bool checks whether a Text is contained anywhere within another Text. ghci> "rum" `T.isInfixOf` "crumble" True isPrefixOf :: Text -> Text -> Bool checks whether a...

LocalTime is an immutable class and thread-safe, used to represent time, often viewed as hour-min-sec. Time is represented to nanosecond precision. For example, the value "13:45.30.123456789" can be stored in a LocalTime. This class does not store or represent a date or time-zone. Instead...

If you find these steps unfamiliar, consider starting here instead. Note these steps come from Stack Overflow Documentation. django-admin startproject myproject cd myproject python manage.py startapp myapp myproject/settings.py Install the app INSTALLED_APPS = [ 'django.contrib.admin', ...

First we need to make a ViewModel. Make a new folder /Models/Account, and add the file MemberLoginViewModel.cs to the folder. using System; using System.Collections.Generic; using System.ComponentModel.DataAnnotations; using System.Linq; using System.Web; namespace MyCMS.Models.Account { ...

Then make a view in the folder /Views/MacroPartials/Account @model MyCMS.Models.Account.MemberLoginViewModel @using MyCMS.Controllers.Account @if (User.Identity.IsAuthenticated) { <p>Logged in as: @User.Identity.Name</p> using (Html.BeginUmbracoForm<MemberLogin...