Angular 2 CLI

Angular 2 CLI
:: Installation ::

npm install -g angular-cli

:: Create and run a working Angular 2 app ::

ng new PROJECT_NAME cd PROJECT_NAME ng serve

:: Up and running :: Navigate to http://localhost:4200/

Angular 2 CLI

ASP.NET Telerik Combo Box control issue with backspace

<telerik:RadComboBox runat="server" ID="RadComboBox1" AllowCustomText="true" EmptyMessage="" Width="85%" EnableEmbeddedSkins="false" DataTextField="Code" DataValueField="Id" RenderMode="Lightweight" ToolTip="Impact is Required" MarkFirstMatch="True" OnClientLoad="window.utility.Cbo.onClientLoad">

JS code part:

(function () { 'use strict'; //The namespace window.utility = window.utility || {}; // ComboBox window.utility.Cbo = window.utility.Cbo || {}; window.utility.Cbo.onClientLoad = function (sender) { $telerik.$("#" + sender._inputDomElement.id).on('keyup', function (e) { if (e.keyCode == 8) { var combo = $find(sender._uniqueId.split('$').join('_')); if (!combo || !this.selectionStart || this.selectionStart <= 0) return; var caretPosition = this.selectionStart var comboText = combo.get_text(); if (comboText || comboText.length > 0) { var newComboText = comboText.slice(0, caretPosition - 1) + comboText.slice(caretPosition); combo.set_text(newComboText); --caretPosition; this.selectionStart = (caretPosition < newComboText.length) ? (caretPosition >= 0) ? caretPosition : 0 : newComboText.length - 1 this.selectionEnd = this.selectionStart; } } }) } })();

ASP.NET Telerik Combo Box control issue with backspace

Oracle SQL Developer Keyboard Shortcuts by thatjeffsmith - Cheatography.com: Cheat Sheets For Every Occasion

Oracle SQL Developer Keyboard Shortcuts by thatjeffsmith - Cheatography.com: Cheat Sheets For Every Occasion

Oracle SQL Developer Keyboard Shortcuts by thatjeffsmith - Cheatography.com: Cheat Sheets For Every Occasion

Javascript String.padLeft( len, leadingChar )

String.prototype.padLeft = function padLeft(length, leadingChar) { if (leadingChar === undefined) leadingChar = "0"; return ( this.length < length ) ? (leadingChar + this).padLeft(length, leadingChar) : this; };

Javascript String.padLeft( len, leadingChar )

FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014 :: KB2952444

The performance issue with Table variables with many rows and then join it with other tables has ben fixed by as explained in KB2952444. Before the fix which applied to SQL Server 2012 SP2 and later, the query optimizer may choose an inefficient query plan, which may lead to slow query performance.

https://support.microsoft.com/en-us/kb/2952444

FIX: Poor performance when you use table variables in SQL Server 2012 or SQL Server 2014 :: KB2952444

AngularJS Style Guide by John Papa

AngularJS Style Guide by John Papa
https://github.com/johnpapa/angular-styleguide

AngularJS Style Guide by John Papa

T-sql :: Change just DATE part of a DATETIME

DECLARE @dt DATETIME SET @dt = GETDATE() SELECT DATEADD(dd, DATEDIFF(dd, @dt, '2015-06-01'), @dt)

T-sql :: Change just DATE part of a DATETIME

Set date to first day of the month and end day of the month

Set date to first day of the month:

SELECT DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)

Set date to end day of the month:

SELECT EOMONTH(GETDATE())

Set date to last day of the previous month:

SELECT EOMONTH(GETDATE(), -1)

Remove milliseconds from datetime:

DECLARE @now DATETIME SET @now = GETDATE() SELECT @now SELECT DATEADD(ms, -DATEPART(ms, @now), @now)

Set date to first day of the month and end day of the month

Visual Studio Error List and Output Window shortcuts

To view the Error List window: CTRL + \,E inside the IDE.
To show the Output Window: CTRL + ALT + O.

Visual Studio Error List and Output Window shortcuts

Visual Studio Immediate Window shortcut

To get in the immediate window in Visual studio ::
Debug --> Windows --> Immediate
Ctrl + Alt + I

Visual Studio Immediate Window shortcut