Tutorial by Examples: d

For getting the next 10 rows just run this query: SELECT * FROM TableName ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY; Key points to consider when using it: ORDER BY is mandatory to use OFFSET and FETCH clause. OFFSET clause is mandatory with FETCH. You can never use, ORDER BY … FETC...

Since every Applicative Functor is a Functor, fmap can always be used on it; thus the essence of Applicative is the pairing of carried contents, as well as the ability to create it: class Functor f => PairingFunctor f where funit :: f () -- create a context, carrying nothing ...

NSMutableAttributedString * string = [[NSMutableAttributedString alloc] initWithString:@"firstsecondthird"]; [string addAttribute:NSForegroundColorAttributeName value:[UIColor redColor] range:NSMakeRange(0,5)]; [string addAttribute:NSForegroundColorAttributeName value:[UIColor greenColo...

Dependenct Injection Intro An application is composed of many objects that collaborate with each other. Objects usually depend on other objects to perform some task. When an object is responsible for referencing its own dependencies it leads to a highly coupled, hard-to-test and hard-to-change code...

This example will demonstrate how to use Dependency Injection (DI) design pattern in Swift using these methods: Initializer Injection (the proper term is Constructor Injection, but since Swift has initializers it's called initializer injection) Property Injection Method Injection Example Set...

Let's say we have a form like the one below. We want to send the data to our webserver via AJAX and from there to a script running on an external server. So we have normal inputs, a multi-select field and a file dropzone where we can upload multiple files. Assuming the AJAX POST request was succ...

//Create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //Set some properties of the Excel document excelPackage.Workbook.Properties.Author = "VDWWD"; excelPackage.Workbook.Properties.Title = "Title of Document"; excelPackage.Workboo...

Session storage service : Common factory service that will save and return the saved session data based on the key. 'use strict'; /** * @ngdoc factory * @name app.factory:storageService * @description This function will communicate with HTML5 sessionStorage via Factory Service. */ a...

If a view is created WITH SCHEMABINDING, the underlying table(s) can't be dropped or modified in such a way that they would break the view. For example, a table column referenced in a view can't be removed. CREATE VIEW dbo.PersonsView WITH SCHEMABINDING AS SELECT name, address FROM d...

//Using File.WriteAllBytes using (ExcelPackage excelPackage = new ExcelPackage()) { //create a new Worksheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //add some text to cell A1 worksheet.Cells["A1"].Value = "My secon...

//create a new ExcelPackage using (ExcelPackage excelPackage = new ExcelPackage()) { //create the WorkSheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //add some text to cell A1 worksheet.Cells["A1"].Value = "My second...

The first to thing to have: a model that contains a has_many relation with another model. class Project < ApplicationRecord has_many :todos end class Todo < ApplicationRecord belongs_to :project end In ProjectsController: class ProjectsController < ApplicationController d...

It is a bad practice to block on async calls as it can cause deadlocks in environments that have a synchronization context. The best practice is to use async/await "all the way down." For example, the following Windows Forms code causes a deadlock: private async Task<bool> TryThis()...

//Using File.WriteAllBytes using (ExcelPackage excelPackage = new ExcelPackage()) { //create a new Worksheet ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet 1"); //add some text to cell A1 worksheet.Cells["A1"].Value = "My fourt...

The easiest way to record a macro is the button in the lower left corner of Excel looks like this: When you click on this you will get a pop-up asking you to name the Macro and decide if you want to have a shortcut key. Also, asks where to store the macro and for a description. You can choose any ...

<html> <body> <% out.print("Today is:"+java.util.Calendar.getInstance().getTime()); %> </body> </html>

A data structure is a way of organizing and storing information. Let a "Hello, World!" string be the information that we need to organize and store in byte-addressable memory. Each ASCII character requires 7 bits of storage. Most systems reserve 8 bits (1 byte) for each character, so eac...

Ifconfig List all the interfaces available on the machine $ ifconfig -a List the details of a specific interface Syntax: $ ifconfig <interface> Example: $ ifconfig eth0 eth0 Link encap:Ethernet HWaddr xx:xx:xx:xx:xx:xx inet addr:x.x.x.x Bcast:x.x.x.x Mask:x.x.x.x ...

An IP address to an interface could be obtained via DHCP or Static assignment DHCP If you are connected to a network with a DHCP server running, dhclient command can get an IP address for your interface $ dhclient <interface> or alternatively, you could make a change to the /etc/network/...

File: /etc/hosts contains a list of hosts that are to be resolved locally(not by DNS) Sample contents of the file: 127.0.0.1 your-node-name.your-domain.com localhost.localdomain localhost XXX.XXX.XXX.XXX node-name The file format for the hosts file is specified by RFC 952