Cursors In this article, I want to tell you how to create and use server side cursors and how you can optimize a cursor performance. Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the...

Inner Join:   Inner Join is a default type join of SQL Server. It uses logical operators such as =, <, > to match the records in two tables. Inner Join includes equi join and natural joins.   Outer Join: Outer Join has further 3 sub categories as left, right and full. Outer...

Concept of OOPS   EncapsulationAbstraction InheritancePolymorphism   Encapsulation:             The wrapping of data and function together in a single unit is called encapsulation. It tell how to bind data.this is useful to hide...

Download Visual Studio 2010 First, if you want it, go download Visual Studio 2010 now. If you're an MSDN Subscriber or WebSiteSpark/BizSpark member, you can download the final release now. If not, you can download a free trial or one of the free Express editions. Microsoft Visual Studio...

WindowsXP VPN Server The following page details the steps necessary to create a WindowsXP VPN Server 1. Go to Start / Settings / Network Connections 2. Start the New Connection Wizard 3. Click on the Next button 4. Select Set up advanced...