Tag: Technical

Aug 14

SQL SERVER – Difference Between Union and Union All

SQL SERVER – Difference Between Union and Union All UNION:   The UNION command is used to select related information from two tables, much like the JOIN command. However, when using the UNION command all selected columns need to be of the same data type. With UNION, only distinct values are selected.   UNION ALL: …

Continue reading

Permanent link to this article: http://zappmania.in/2013/08/14/sql-server-difference-between-union-and-union-all.htm

Jun 28

What are session management techniques in .NET?

There are three different techniques of managing session in ASP.NET InProc  Session state is stored locally in memory of ASP.NET worker process. StateServer  Session state is stored outside ASP.NET worker process and is managed by Windows service. Location of this service is specified by stateConnectionString attribute. SQLServer  Session state is stored outside ASP.NET worker process …

Continue reading

Permanent link to this article: http://zappmania.in/2012/06/28/what-are-session-management-techniques-in-net.htm