Rank()
Rank function will generates a unique number to each distinct row, but it leaves a gap between the groups.
Dense_Rank()
Dense_Rank function is similar to Rank with only difference, this will not leave gaps between groups.
DECLARE @Table TABLE (
column varchar(2)
)
INSERT INTO @Table (column)
VALUES ('A'),('A'),('A'),('B'),('B'),('C'),('C');
SELECT
...
Nov 30, 2015
Nov 27, 2015
Difference between ToClone and ToCopy method in .Net
ToClone will copy the structure of a data where as ToCopy will copy the complete structure as well as data.
var strArr1 = new string[] { "1", "2", "3","4" };
var strArr2 = strArr1 ; //copy
var strArr3 = new string[] { "1", "2", "3","4" };
var strArr2 = strArr1.ToClone(); //Clone...
Nov 19, 2015
Node.js has been released new stable version v5.1.0
Node.js has been release new stable version 5.1.0, couple of days ago.
Its a good news for Node.js lover that they got new stable release version 5.1.0 with bug fixes and few notable changes.
For more detail please visit official website...
Nov 17, 2015
JavaScript error SCRIPT1002: Syntax error
9:11 PM
JavaScript, jquery, SCRIPT1002: Syntax error
No comments
SCRIPT1002:Syntax error occurred most probably in Internet Explorer.
First we try to re-procedure the issue writing below code.
$(document).ready(function() {
$("#linkButton").click(function() {
alert('Hello World');
});
});
Click Me!
Yes, that is the problem. void is...
Nov 5, 2015
Asp.Net 5 and MVC 6 new features.
5:20 PM
asp.net, Asp.Net 5, asp.net 5 features, asp.net MVC 6, MVC 6 features
No comments
As I already Written blog for Asp.Net 5 and MVC 6 difference on my previous blog.
Here I am going to little more explore about Asp.Net 5 and talking about new feature included in Asp.Net 5.
Listing few features,
Asp.Net...
Nov 2, 2015
What is the difference between Asp.Net 5 and Asp.Net MVC 6?
10:52 AM
asp.net, Asp.Net 5, asp.net MVC 6, MVC 6
No comments
Asp.Net 5
It is an open source cross-platform framework for building modern web applications that can be developed and run cross-platforms like Windows, Linux and the Mac. It consists of modular components with minimal overhead, so you retain flexibility while constructing your solutions. It includes the MVC 6 framework, which now combines the features...
