Tutorial by Examples: i

SELECT DATEDIFF(DAY, login_time, getdate()) UpDays FROM master..sysprocesses WHERE spid = 1

Since a Vimscript file is a collection of Command mode actions, the user needs to specify that the desired actions should be executed in normal mode. Therefore executing a normal mode command like i, a, d etc. in Vimscript is done by prepending the command with normal: Going to the bottom of the f...

If you are running a command that returns hundreds of lines, but your interest is just on the lines that contains the word <word>, you should definitely use grep! For example try running: ifconfig -a Check the output, that could be only a few lines or quite long, if you have a server with ...

This tutorial will guide you through the process from scratch. Please note some preliminary notes about this particular setup, useful in case that you already have some requested package: Is needed a version of php >=5.0 (I had troubles with php 7.0) Is requested any version of perl Is need...

To target Internet Explorer 6 and Internet Explorer 7, start your properties with *: .hide-on-ie6-and-ie7 { *display : none; // This line is processed only on IE6 and IE7 } Non-alphanumeric prefixes (other than hyphens and underscores) are ignored in IE6 and IE7, so this hack works for any...

To target Internet Explorer 8, wrap your selectors inside @media \0 screen { }: @media \0 screen { .hide-on-ie8 { display : none; } } Everything between @media \0 screen { } is processed only by I

You can create and configure build types in the module-level build.gradle file inside the android {} block. android { ... defaultConfig {...} buildTypes { release { minifyEnabled true proguardFiles getDefaultProguar...

To create a blank image, use the imagecreatetruecolor function: $img = imagecreatetruecolor($width, $height); $img is now a resource variable for an image resource with $widthx$height pixels. Note that width counts from left to right, and height counts from top to bottom. Image resources can al...

An image can be created using image* functions, where * is the file format. They have this syntax in common: bool image___(resource $im [, mixed $to [ other parameters]] ) Saving to a file If you want to save the image to a file, you can pass the filename, or an opened file stream, as $to. If ...

<ItemGroup> <DataToCopy Include="*.cs;*.aspx" /> </ItemGroup> <Copy SourceFiles="@(DataToCopy)" DestinationFolder="SourceCopiedFolder" />

Software and hardware prerequisites for installation of BizTalk Server (All versions) Software requirements 1. Development environment Below software tools are required for BizTalk environment, not all of them are needed, but having all might add some advantage for developing BizTalk applications...

A Haskell's Functor allows one to map any type a (an object of Hask) to a type F a and also map a function a -> b (a morphism of Hask) to a function with type F a -> F b. This corresponds to a Category Theory definition in a sense that functor preserves basic category structure. A monoidal ca...

See discussions in "GRANT" and "Recovering root password".

Usually this means that the Master crashed and that sync_binlog was OFF. The solution is to CHANGE MASTER to POS=0 of the next binlog file (see the Master) on the Slave. The cause: The Master sends replication items to the Slave before flushing to its binlog (when sync_binlog=OFF). If the Master cr...

In some cases basic validation is not enough. Angular support custom validation adding validator functions to the $validators object on the ngModelController: angular.module('app', []) .directive('myValidator', function() { return { // element must have ng-model attribute // o...

It may be helpful to include additional information with an exception, e.g. for logging purposes or to allow conditional handling when the exception is caught: class CustomError < StandardError attr_reader :safe_to_retry def initialize(safe_to_retry = false, message = 'Something went wro...

English text has the occasional diacritics. Loan words, like née, café, entrée Names, like Noël and Chloë Place names, like Montréal and Québec

Emoji are quite popular with social media these days. ☃: U+2603 — SNOWMAN 😀: U+01F600 — GRINNING FACE 🐪: U+01F42A — DROMEDARY CAMEL Note that most emoji are outside the Basic Multilingual Plane. A lot of newer additions consist of more than one code point: 🇯🇵: A flag is defined as a p...

Almost all written text has punctuation marks which are outside the ASCII character set: dashes: the en dash –, and the em dash — Quotation marks: “quotes” rather than "quotes" The ellipsis…

There are a few common symbols in use: copyright sign ©, and trademark signs ® ™ fractions like ¼ superscripts. For instance, a shorthand for square meters is m².