Difference Between Where and Having Clause

The WHERE clause does not work with aggregates like SUM,Count etc. The SQL above will not work, because the where clause doesn’t work with aggregates – like sum, avg, max, etc.. Instead, what we will need to use is the having clause. The having clause was added to sql just so we could compare aggregates to other values – just how the ‘where’ clause can be used with non-aggregates....

Difference Between System.Web and System.WebServer

System.web is the settings section for IIS6 and the built in cassini server (the test server in Visual Studio 2010 and before where you are targeting asp.net 3.5 or lower) The system.webserver is a child of the configuration section that means in web.config file <system.webserver> tag is placed under <configuration> Tag. System.WebServer Tag is contained in web.config...

Difference Between http get and jsonp

An HTTP GET request is what you get when you enter a URI in your browser or when you click on a link on a web page. Certain HTML elements, like also generate GET requests. GET requests a resource from the server. You can pass additional information to a server-side script by adding 'query parameters' after the script, such as Example Domain. Say you're on domain www.example.com,...

Angularjs Vs Jquery

Answer Angularjs Vs Jquery On Quora Angularjs Vs Jquery jQuery will be used for things like higher level APIs, updating DOM elements, adding classes and wrapping XHR calls up nicely. Angular 1.x actually uses jQuery lite (jQLite) inside itself, or can use the full jQuery...

Difference between on and bind in jQuery

The .bind() method registers the event and event handler directly to the DOM element.This method is still very handy when wiring-up event handlers, but there are various performance concerns as are listed below. Internally .bind() maps to .on() as per current version of Jquery .bind may be removed from future versions at any time. There is no reason to keep using .bind and every...

Grunt vs Gulp

Gulp and Grunt are both Automated Task Runner . Major Difference Between Gulp and Grunt Lies in How They Deal With Automation of Tasks Internally .Gulp Uses Node Streams For running different tasks and Grunt use temp files for the same work . Grunt runns tasks using Temporary...

Difference Between Bower and NPM

Npm and Bower are both Project dependency management tools. But the main difference between both is npm is used for installing Node js modules but bower js is used for managing front end components like html,css,js etc. npm is most commonly used for managing Node.js modules, but it works for the front-end too when combined with Browserify etc Bower is front-end Package...

Benefits of Html Helpers in Asp.Net MVC

So today i am going to give an overview on Html helpers in Asp.Net MVC . So first questions that stuck our mind are -  What are Html helpers ?  Why to use them instead of using simple Html coded controls  What are their benefits in Asp.Net MVC Html helpers are very much similar to Asp.Net web controls . But Html helpers are much more lightweight as compared...

Advantage of Asp.Net MVC

Asp.net  is a part of .net platform for creating,building, deploying and running web applications using C#,VB etc .we can develop a web application by using Asp.Net Web Form and Asp.Net MVC. Asp.Net MVC is advanced technology that is most widely used nowadays . MVC is a great...

Difference Between ViewState and Session in Asp.Net

"View State and Session "   The Two main State Management things used in Asp.net Web applications . We cannot even think of an application without ViewState and Session . So today i decided to gave an overview of what is the difference between viewstate and session why these two terms exist and what are their usage To clearify this difference i am giving some points below 1....

Difference Between C programming and C++ programming Language

DIFFERENCE BETWEEN PROCEDURAL AND OBJECT ORIENTED PROGRAMMING 1.         C Follows Procedural Programming Approach . It is also called  Structured programming approach. In Structured programming approach  the program has well defined structure...