SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

How to get 1st, 2nd, 3rd, 4th, nth topmost salary from an Employee tableThe following solution is for getting 6th highest salary from Employee table ,SELECT TOP 1 salaryFROM (SELECT DISTINCT TOP 6 salaryFROM employeeORDER BY salary DESC) aORDER BY salaryYou can change and use it for getting nth highest salary from Employee table as followsSELECT TOP 1 salaryFROM (SELECT DISTINCT TOP n salaryFROM employeeORDER...

.Net FAQ

Difference between a.Equals(b) and a == b If both a and b are value type then then you will get same result in a.Equals(b) and a == b. but in case of reference type both behaves differently : eg. string a = new string(new char[] {'d', 'a', 'n', 'c', 'e'}); string b = new string(new char[] {'d', 'a', 'n', 'c', 'e'}); object c = a; object d = b; Console.WriteLine (a==b); Console.WriteLine (a.Equals(b));...

What is CLR,CLS,CTS,MSIL,JIT??

What is a .Net Assembly?The .NET assembly is the standard for components developed with the Microsoft.NET. Dot NET assemblies may or may not be executable, i.e., they might exist as the executable (.exe) file or dynamic link library (DLL) file. All the .NET assemblies contain the definition of types, versioning information for the type, meta-data, and manifest. The designers of .NET have worked a...

Sharepoint 2010 Virtual lab

Sharepoint 2010 Virtual labMSDN Virtual Lab: SharePoint Server 2010: Advanced Search Security New!MSDN Virtual Lab: SharePoint Server 2010: Configuring Search UIs New!MSDN Virtual Lab: SharePoint Server 2010: Content Processing and Property Extraction New!MSDN Virtual Lab: SharePoint Server 2010: Developing a Custom Connector New!MSDN Virtual Lab: SharePoint Server 2010: Fast Search Web Crawler New!MSDN...

Publish a .NET 3.5 Website to Windows Server 2008 IIS 7

Publish a .NET 3.5 Website to Windows Server 2008 IIS 7 Install the Web Server Role •In Role Services, select ASP.NET and continue.Install the .NET 3.5 Framework•On your webserver, install the .NET 3.5 framework.Publish Your Application•In Visual Studio, publish your web project to a local folder, like on the desktop.•Copy that folder to a local folder on the webserver, maybe somewhere like c:\apps.•From...

Exploring the Global.asax file in ASP.NET

Exploring the Global.asax file in ASP.NET Have you ever felt the need of writing logic at the application level; precisely a location or a file where you could handle events or errors at the application level? Well if yes, then enter the Global.asax. Using this file, you can define event handlers with application-wide or session-wide scope. In this article, we will explore the application and session...

Asp.net links

Save and Retrieve Images from the Database using ASP.NET 2.0 and ASP.NET 3.5Exploring the Global.asax file in ASP.NET Cross Page Posting In ASP.NET ...

LINQ to SQL Full

LINQ to SQL Part 1: Introduction to LINQ to SQLPart 2: Defining our Data Model ClassesPart 3: Querying our DatabasePart 4: Updating our DatabasePart 5: Binding UI using the ASP:LinqDataSource ControlPart 6: Retrieving Data Using Stored ProceduresPart 7: Updating our Database using Stored ProceduresPart 8: Executing Custom SQL Expressi...

Installing SharePoint Server-2010

Installing SharePoint Server-20101)How to install SPS2010 in Single Box Development Server?2)Create a Sharepoint 2010 VM in 32 bits host machineDownload doc for details1)How to install SPS2010 in Single Box Development Server?1. After you have finished installing OS, start to add Active Directory Domain Service roles. Complete the installation procedure and configure the roles.2. Then, start...