The Open Closed Principle of SOLID

The Open Closed Principle of SOLID Principle   SOLID principles are like the backbone of OOP, I've gone through with this and obtained a good understanding of this and I thought to share it so that anyone can understand this principle at MAX.Here is the list of SOLID principles. SRP The Single Responsibility Principle A class should have...

Categories: C# , Design Pattern & OOPS

Difference between ROW_NUMBER() OVER () & PARTITION BY clause

Difference between ROW_NUMBER () OVER () & PARTITION BY clause     This is one of the main basic and needed terms which you may have used in your daily uses in SQL Server and off course one of the main interview question.   Before jumping into code indeed lets understand what it means by ROW_NUMBER() & PARTITION BY clause....

Categories: SQL Server

Select data of a table from another database in SQL Server 2008R2

Select data of a table from another database in SQL Server 2008R2 In this short snippet blog I’ve demonstrate a condition to use two databases / schemas on the same database server, you can query across databases with the given below syntax : 1: select * from database1.dbo.table1 t1 join database2.dbo.table2 t2 on t1.column_Name= t2.column_Namee.g....

Categories: SQL Server

Controller to Controller Communication Using $RouteScope in AngularJS

Controller to Controller Communication Using $RouteScope in AngularJS Here I've merely thought to write my thoughts and hands-on experience with Angular. This is another article that tells you how to get your hands dirty with Controller to Controller communication using $RouteScope in AngularJs AngularJs.I've designed a program to help you become...

Categories: AngularJS

Integration of Google ReCaptcha With MVC4 Application

Integration of Google ReCaptcha With MVC4 Application It is in trend these days to verify that a user is a human or not and the easiest and most used option to do this is to have Google ReCaptcha in your application. This article elaborates how to integrate Google reCaptcha in a MVC4 application. After going through with this article you may get...

Categories: MVC