ASP.NET AT A GLANCE

ASP.NET AT A GLANCE: Nth Maximum in SQL

DECLARE @empSalary table (     empid int not null primary key identity(1,1),     name varchar(100),     salary decimal(18,2) ) declare @i int set @i = 1 while @i <= 100 begin     insert INTO @empSalary (name, salary)     VALUES('emp ' + convert(nvarchar(10), @i), '100' + convert(nvarchar(10), @i))     set @i = @i + 1 end Declare @cnt int Declare @total int Set @cnt = 295 Select @cnt = max(empid) from @empSalary IF @cnt <= @total begin     Select top 1 salary from @empSalary where salary in (Select top (@cnt) salary from @empSalary order by salary desc ) end else begin     Select 'Not Found' end

What is .NET 3.0? In one simple equation .NET 3.0 = .NET 2.0 + Windows Communication Foundation + Windows Presentation Foundation + Windows Workflow Foundation + Windows Card Space. What is Windows Card Space? It was previously known by its codename Info Card. It is a framework by Microsoft, which securely stores digital identities of a user and provides a unified interface to choose the identity for a particular transaction, such as logging in to a website. Windows Card Space is a central part of Microsoft’s effort to create an identity met system, or a unified, secure and interoperable identity layer for the internet. What is WCF? First let us give a short answer to this: - “WCF (Indigo was the code name for WCF) is a unification of .NET framework communication technologies “.WCF is a unification technology, which unites the following technologies:- • NET remoting • MSMQ • Web services • COM+. Below figure depicts WCF fundamentals pictorially. Figure: 1 - WCF Componen...