Back to Basics – Series :: Cool links for getting to know about the Different Types of Joins in SQL Server. http://www.c-sharpcorner.com/UploadFile/raj1979/SqlJoins10012008164642PM/SqlJoins.aspx http://programming.top54u.com/post/Types-of-Joins-in-Sql-Server-2005.aspx Have Fun!! Happy Coding!!!
Read more →SQL Query for ‘n’ th highest salary of employee table
IGate Recruitment, in written test has asked about to write an sql query for finding ‘n’ th highest salary from empolyee table. Here is a quick solution Query for Creating Test Table and inserting dummy data. SQL Query for Retrieving the ‘n’ th largest salary from EMPLOYEE table.
Read more →Abstract vs Interface (C#): A Simple Tabular Index
I found that lots of people our there are confused between abstract and interface, including me :-). So i formulated this simple table which list most of the differences between them. Index Abstract Interface 1 Cannot instantiate(not possible to create object of an abstract class) Cannot instantiate. (not possible to create object of an interface) […]
Read more →How to Fix Startup Times in Windows 7
Sandro Villinger wrote an excellent article on speeding up boot-times, most of these articles do not go further than msconfig.exe, this article does. Windows 7 is a fast beast, especially when it comes to its startup process which was optimized dramatically compared to Windows Vista. No wonder, as Microsoft has a dedicated team focusing strictly […]
Read more →Back-2-Basics : Largest and Second Largest in an Array(C#)
It’s a basics code, just sharing it since since will be useful for some body, who is in needy. I am just refresing my OOPS and Basic knowledge, just experimenting. Ha ha ha. Advice to guyz, don’t simply copy it, try to understand the logic and do it by yourself. PS: I have tested this […]
Read more →A Tricky Interview Qn – VB.NET DLL & C# Application Interoperability
Recently I have been asked about a question in 2 interviews. There is a VB.NET Library which has a class having the following methods Developer has compiled it and Add reference to it in a C# Console Application. How the developer can use all these methods in C# ? The Concept in question was C# […]
Read more →