RowNumber in Select Query
It is a common issue of many of the guys on how we can fetch a record based on its…
Use Visual Studio Server Explorer to Add New or Existing SQL Server CE Database
SQL CE is a free, embedded, lightweight database engine that enables easy database storage. This does not required any installation…
Common Table Expressions
If you think only .NET languages are the only thing that is getting evolved day by day while SQL Syntaxes…
How to count number of active session for State Server Session Mode ?
While dealing with ASP.NET Session, generaly we use Session_Start() method in Global.aspx for count the number of active session, as…
How to calculate Session data size for SQL Server session mode?
SQL Server use ASPState database to store the session information for SQL Server Session mode. ASPState database having two tables…
