Selecting the Top N in each Category

When we write queries in TSQL selecting the top ‘n’ number of rows is easy. It can be achieved by a query similar to the following. SELECT TOP(10) Names FROM [Users] WHERE IsActive = 'True' ORDER BY ApprovedOn DESC But when selecting the items which are from different tables and with subcategories this is quite … Continue reading Selecting the Top N in each Category

SQL Stored Procedures

You can have a good sample on SQL Server Stored procedures using ADO.NET in C# in this link. http://www.codeproject.com/KB/cs/simplecodeasp.aspx The article is simple and easy to understand. Feel free to ask any questions on stored procedures as I will try my best to answer.

SQL Server Protocols

Based on some missing images this document might appear in a broken flow SQL Server is the Microsoft’s Enterprise Data Management system. Recent release is SQL Server 2008 R2 (x64 bit only). We all know about the Database Management System and Database related concepts. SQL Server comes with two powerful tools SQL Server Management Studio … Continue reading SQL Server Protocols