Tutorial by Examples: d

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

class MyResourceAdapter implements javax.resource.spi.ResourceAdapter { public void start(BootstrapContext ctx){..} public void stop(){..} public void endpointActivation (MessageEndpoingFactory mf, ActivationSpec a){..} public void endpointDeactivation (MessageEndpoingFact...

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

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

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

Trace flags in SQL Server are used to modify behavior of SQL server, turn on/off some features. DBCC commands can control trace flags: The following example switches on trace flag 3205 globally and 3206 for the current session: DBCC TRACEON (3205, -1); DBCC TRACEON (3206); The following examp...

DBCC statements act as Database Console Commands for SQL Server. To get the syntax information for the specified DBCC command use DBCC HELP (...) statement. The following example returns all DBCC statements for which Help is available: DBCC HELP ('?'); The following example returns options f...

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!'

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

Make a new controller in the folder /Controllers/Account. Name the file MemberLoginSurfaceController.cs using MyCMS.Models.Account; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using System.Web.Security; namespace MyCMS.Controll...

{-# LANGUAGE OverloadedStrings #-} import qualified Data.Text as T myText :: T.Text myText = "mississippi" Characters at specific indices can be returned by the index function. ghci> T.index myText 2 's' The findIndex function takes a function of type (Char -> Bool) ...

Processing provides method ellipse in order to draw ellipse. This code draws a white circle which has radius of 25 pixels. void setup() { size(500, 500); background(0); fill(255); noStroke(); } void draw() { ellipse(225, 225, 50, 50); } The signature of method ellip...

Git config allows you to customize how git works. It is commonly used to set your name and email or favorite editor or how merges should be done. To see the current configuration. $ git config --list ... core.editor=vim credential.helper=osxkeychain ... To edit the config: $ git config &lt...

Diamond problem is a common problem occurred in Object Oriented Programming, while using multiple-inheritance. Consider the case where class C, is inherited from class A and class B. Suppose that both class A and class B have a method called foo(). Then when we are calling the method foo(), compil...