ASP.NET 2.0 Tutorials - No Need of Google!!

Excellent and daily use code grocerry shop for ASP.NET 2.0....

http://www.asp.net/QuickStart/aspnet/default.aspx

Happy Programming!!

HttpHandler and HttpModule

http://www.theserverside.net/articles/showarticle.tss?id=IIS_ASP

Performance Considerations for Run-Time Technologies in the .NET Framework

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/dotnetperftechs.asp

Performance Tips and Tricks in .NET Applications

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/dotnetperftips.asp

Rescue to all kind of Debugging in .NET !!

http://www.gotdotnet.com/team/csharp/learn/whitepapers/howtosolvedebuggerproblems.doc

One Stop Shop of Connection Strings !!

http://www.connectionstrings.com/

Top Intv Ques: Nth Highest Salary of Emp !!

I m always having trouble to build this query but now i got it forever!!!

Say "Emp" table structure is:

EmpID Salary
1 100
2 500
3 200
4 400

Say we have to find 2nd highly paid employee...Here we go.....::

select Salary from Emp A where 1 = (select count(Salary) from Employee B where B.Salary > A.Salary)

Note: "1" in above query is Nth Max - 1 or in other words if we have to find say 3rd highest see how many are there above three ?? Obviously two sp put 2 na intead of 1....(here we are looking for 2nd highest thats why i have put 1...Samje...)


Simple and Perfect....Kya baat hai!!! Wah Wah....

Excellent E-Books

Here i got good collection of e-books....

http://www.maththinking.com/boat/booksIndex.html