SQL Server Group by Alias Column Name with Example

Introduction:

Here I will explain how to group by alias column name in sql server or alias column name in sql server or how to use group by on an alias column in sql server. To implement group by on alias column name in sql server we need to use the whole expression in group by clause or we need to wrap all sql query statements in subquery and implement grouping on outside of the statement.

Description:

In previous articles I explained sql server get next and previous row values from sequence, sql server get before and after character example, sql server keyboard shortcut keys, sql server show exact match on top then partial match values, SQL Server single procedure to insert update delete, Primary key constraint in sql server, foreign key constraint in sql server and many articles relating to SQL server. Now I will explain how to group by alias column name in sql server.

Asp.Net Cookies - Read / Get / Create Cookies in Website using C#, VB.NET

Introduction: 

Here I will explain how to read cookies in asp.net using c#, vb.net with example or create or get cookie value from asp.net website using c#, vb.net with example or check if cookie exists or not in asp.net website using c#, vb.net with example. By using “Request.Cookies” properties we can get or read cookie value from asp.net website using c#, vb.net.

Description:
  
In previous articles I explained asp.net memebership tutorial with examples, Get user ip address in asp.net, jQuery bootstrap auto complete textbox in asp.net, Bind specific columns of datatable to datagridview in c#, bind gridview using jquery json method in asp.net, show multiple markers in google map from database in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to create or get / read cookie values from asp.net website using c#, vb.net with example.

Bootstrap Accordion with Plus Minus Icons Example

Introduction: 

Here I will explain how to create bootstrap accordion with plus minus icons or bootstrap accordion with plus and minus example or how to show / add plus minus icons to bootstrap accordion menu with example.

Description:
  
In previous articles I explained jQuery vertical accordion menu example, Bootstrap autocomplete textbox example in asp.net, Bootstrap dropdownlist with checkboxes in jQuery, Bootstrap set particular tab opened in jQuery, jQuery autocomplete textbox with multiple words in asp.net, jQuery slideup, slidedown, slidetoggle effects example and many articles relating to autocomplete, bootstrap, css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to create bootstrap accordion with plus / minus icons example.

Asp.net MVC Hello World Example in C#

Introduction:

Here we will learn asp.net mvc hello world example or how to create simple hello world example in asp.net mvc or hello world first asp.net mvc application or learn asp.net mvc with simple hello world example or asp.net mvc hello world application with step by step process.

Description:
  
In previous articles I explained asp.net mvc cross site request forgery attacks prevention, asp.net mvc membership provider with example, asp.net mvc use hidden fields with html helpers, asp.net mvc exception handling with example, view model in asp.net mvc with example, Step by step asp.net mvc tutorial, Create asp.net mvc image or photo gallery in c# and many articles relating to asp.net mvc, asp.net, c#,vb.net and jQuery. Now I will explain how to create a simple hello world application in asp.net mvc with example.

Convert Pen Drive as Bootable Device using cmd in Windows 10 / 8

Introduction: 

Here I will explain how to convert pen drive into bootable device using cmd in windows 10 or convert pen drive as bootable using cmd in windows 10 or how to make pen drive bootable using windows command prompt in windows 10 or create bootable usd drive using cmd in windows 10. We can make pen drive bootable using cmd for windows 8 / windows 10 easily.  

Description:
  
In previous articles I explained how to fix blurry font for windows 10, excel find and highlight duplicate columns, keyboard keyboard shortcut key codes, compare two columns values and show duplicate values in excel, create desktop shortcut key to lock computer, configure dns server in windows 7. Now I will explain how to make pend drive as bootable device using cmd (command prompt).

C# - Difference between Initialization and Instantiation

Introduction:

Here I will explain difference between initialization and instantiation in c#, vb.net with example or instantiation vs initialization in asp.net or how to instantiate and initialize a class in asp.net using c#, vb.net with example. In c# or vb.net instantiation means declaring object for class and initialization means assigning values to variables or setting initial values.

Description:

In previous posts I explained cursor in sql server with example, oops concepts in c# with examples, difference between dispose vs finalize method, difference between pageload and page_init in asp.net, constructors in c#, vb.net, delegates in c# with example and many articles relating to interview questions, asp.net, c#.net. Now I will explain difference between instantiation and initialization in c#, vb.net with example.

C# - Difference between Instantiation and Inheriting (Inheritance) a Class

Introduction:

Here I will explain difference between instantiation and inheriting (inheritance) a class in c#, vb.net with example or instantiation vs inheritance in asp.net or how to instantiate and inherit a class in asp.net using c#, vb.net with example. In c# or vb.net instantiation means declaring object for class and inheritance means acquiring properties from base class.

Description:

In previous posts I explained @@IDENTITY vs SCOPE_IDENTITY () vs IDENT_CURRENT, difference between dispose and finalize method in c#, authorization in asp.net, difference between page_init and page_load events in asp.net, difference between ref and out parameters in c#, delegates in c# with example and many articles relating to interview questions, asp.net, c#.net. Now I will explain difference between instantiation and inheritance in c#, vb.net with example.

jQuery Show Hide Div Element on Scroll Position Example

Introduction:

Here I will explain how to use jQuery to show hide div element on scroll position or show hide div on scroll position in jQuery or show / hide element on scroll jQuery. In jQuery by using window.scroll property we can show or hide div element based on position.

Description:
  
In previous articles I explained jQuery show / hide div when checkbox is checked (selected), jQuery show / hide / toggle div example, jQuery show / hide loading image in autocomplete textbox, jQuery hide div if we click outside of it example, jQuery show images in 360 degree view plugins and many articles relating to css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to show or hide div on scroll position in jQuery with example.

Asp.Net MVC Cross-Site Request Forgery (csrf) Attacks Prevention

Introduction:

Here we will learn how to prevent cross-site request forgery (csrf) attacks in asp.net mvc with example or asp.net mvc preventing cross-site request forgery (csrf) attacks or understand cross-site request forgery attacks in asp.net mvc or fix / stop cross-site request forgery attacks in asp.net mvc with example. To prevent cross site request forgery attacks we need to use AntiForgeryToken concept in asp.net mvc.

Description:
  
In previous articles I explained create roles, users and assign roles to users in asp.net mvc membership provider, asp.net mvc send query string parameters to controller, use hidden fields in asp.net mvc with html helpers, asp.net mvc custom route constraints with example, view models in asp.net mvc with example, areas in asp.net mvc with example and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how to prevent cross site request forgery attacks in asp.net mvc with example.

SSMS 2014 Ctrl+R Shortcut to Show or Hide Query Results Pane

Introduction:

Here I will explain enable Ctrl + R shortcut to show or hide results pane in sql server or Ctrl + R shortcut key to show / hide results pane missing in ssms 2014 or Ctrl + R shortcut key not working in ssms 2014 to show or hide results pane. In sql server 2014 Ctrl + R option to show or hide results pane has been disabled by default so we need to enable it manually by changing options of ssms 2014.

Description:

In previous articles I explained sql server get previous and next row values from sequence, sql server keyboard shortcut keys, sql server get hours, minutes, date, time from datetime field, sql server insert update delete in single stored procedure, sql server difference between @@Identity, scope_identity, ident_current, sql server get before and after character example and many articles relating to SQL server. Now I will explain how to enable Ctrl + R shortcut key to show or hide results pane in sql server.