Tutorial by Examples: t

You can select the last day of month. SELECT (date_trunc('MONTH', ('201608'||'01')::date) + INTERVAL '1 MONTH - 1 day')::DATE; 201608 is replaceable with a variable.

using System.ComponentModel.DataAnnotations.Schema; public class Department { ... public virtual ICollection<Employee> PrimaryEmployees { get; set; } public virtual ICollection<Employee> SecondaryEmployees { get; set; } } public class Employee { ...

using System.ComponentModel.DataAnnotations.Schema; [ComplexType] public class BlogDetails { public DateTime? DateCreated { get; set; } [MaxLength(250)] public string Description { get; set; } } public class Blog { ... public BlogDetails BlogDetail { get...

Any attempt to modify a const object results in undefined behavior. This applies to const variables, members of const objects, and class members declared const. (However, a mutable member of a const object is not const.) Such an attempt can be made through const_cast: const int x = 123; const_cas...

The change the definition of a db column, the query below can be used for example, if we have this db schema users ( firstname varchar(20), lastname varchar(20), age char(2) ) To change the type of age column from char to int, we use the query below: ALTER TABLE users CHANGE age...

When you install Git, you also get its visual tools, gitk and git-gui. gitk is a graphical history viewer. Think of it like a powerful GUI shell over git log and git grep. This is the tool to use when you’re trying to find something that happened in the past, or visualize your project’s history. ...

In Unix, files and directories beginning with a period usually contain settings for a specific program/a series of programs. Dot files are usually hidden from the user, so you would need to run ls -a to see them. An example of a dot file is .bash_history, which contains the latest executed commands...

You will need a domain name from a registrar. In the gh-pages branch of your project repository, or the main branch of your username.github.io repository, create a CNAME file with the contents www.yourdomain.com - the canonical domain. At your registrar's domain configuration page, point your doma...

Note: in the subsequent passages, the terms hash map and hash table are used interchangeably and refer to the same concept, namely, a data structure providing efficient key lookup through use of an internal hash function. Introduction Although R does not provide a native hash table structure, simi...

Following function encapsulates code for using CreateProcess Windows API for launching other programs. It is configurable and can wait until calling process finishes or return immediately. Parameters: FileName - full path to executable Params - command line parameters or use empty string Fold...

C# Maximizing the window driver.Manage().Window.Maximize(); This is fairly straightforward, ensures that our currently active window is maximized. Position of the window driver.Manage().Window.Position = new System.Drawing.Point(1, 1); Here we essentially move the currently active window t...

Building and Installation on Windows 7 Prerequisites If you want to build VTK from latest sources you need git from Here or you can download a snapshot of the code as a zip and unzip on to your disk drive CMake Microsoft Visual Studio 2015 Plenty of free space - atleast a couple of GB to be ...

Exec sp_configure 'show advanced options' ,1 RECONFIGURE GO -- Show all configure sp_configure

Exec sp_configure 'backup compression default',1 GO RECONFIGURE;

sp_configure 'fill factor', 100; GO RECONFIGURE; The server must be restarted before the change can take effect.

USE master; GO -- Set recovery every 3 min EXEC sp_configure 'recovery interval', '3'; RECONFIGURE WITH OVERRIDE;

USE master EXEC sp_configure 'max server memory (MB)', 64 RECONFIGURE WITH OVERRIDE

EXEC sp_configure "number of checkpoint tasks", 4

Like most of the other programming languages, T-SQL also supports IF..ELSE statements. For example in the example below 1 = 1 is the expression, which evaluates to True and the control enters the BEGIN..END block and the Print statement prints the string 'One is equal to One' IF ( 1 = 1) --<-...

We can use multiple IF statement to check multiple expressions totally independent from each other. In the example below, each IF statement's expression is evaluated and if it is true the code inside the BEGIN...END block is executed. In this particular example, the First and Third expressions are ...