ASP.NET Cookies

A cookie is a small bit of text that accompanies requests and pages as they go between the Web server and browser. The cookie contains information the Web application can read whenever the user visits the site. A Visual Studio project with source code is available to accompany this topic: Download. Scenarios Cookies provide a means in Web applications to store user-specific information....

Continue Reading →

Static Class and Constructor

What is a static class?When we use the static keyword before a class name, we specify that the class will only have static member variables and methods. Such classes cannot be instantiated as they don’t need to: they cannot have instance variables. Also, an important point to note is that such static classes are sealed by default, which means they cannot be inherited further.This is because static...

Continue Reading →

SQL- PIVOT and UNPIVOT

You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output. UNPIVOT performs the opposite...

Continue Reading →

SQL - User Defined Functions

This article covers all the basics of User Defined Functions. It discusses how (and why) to create them and when to use them. It talks about scalar, inline table-valued and multi-statement table-valued functions. With SQL Server 2008, Microsoft has introduced the concept of User-Defined Functions that allow you to define your own T-SQL functions that can accept zero or more parameters and return...

Continue Reading →

SQL: Joins

An SQL join is used to combine rows from multiple tables. An SQL join is performed whenever two or more tables are joined in an SQL statement. The different kinds of SQL joins are: INNER JOIN (or sometimes called simple join) LEFT OUTER JOIN (or sometimes called LEFT JOIN) RIGHT OUTER...

Continue Reading →