Installation of Microsoft Visual Studio 2010

Microsoft Visual Studio is a Software Development Tools Kit Developed By "Microsoft Corporation" . Microsoft Visual studio similarly to its previous components consist of Integrated

INTRODUCTION TO VISUAL STUDIO 2010

Visual Basic 2010 is the latest version of Visual Basic launched by Microsoft in 2010. It 

is almost similar to Visual Basic 2008 but it has added many new features. Visual Basic 

has gone through many phases of development since the days of BASIC that was built 

for DOS. BASIC stands for Beginners' All-purpose Symbolic Instruction Code.

Declare Variable in SQL

VARIABLES :- Variables are particular amount of memory area that are used to store the data values required to get producing the desired output from the program or SQL query . But Before using or allowing these variable to hold the specified data values we must declare them . The Declaration Statement of variable also tells the type of data that the variable will hold.

Create Functions in SQL

Functions provide a good way to group some set of statements under a particular valid Function -Name that can used in various portions in Program . Functions allows us to use particular set of statements that will be used a number of times in different portions of program by single name. A particular set of statements used to perform specific function and

Stored Procedures in SQL

Stored Procedures in SQL

Stored Procedures are set of Pre-compiled Queries . By word "Stored Procedures" we mean the set of statement that are only compiled first at time of first time they are compiled and stored and saved on SQL Server for use in future are called as Stored Procedures.

Joins in SQL

Joins in Structured Query Language (S Q L) are used to Store and Retrieve data from two or more Tables . Joins Store and Retrieve data On the basis of given Join Condition. The Given Join condition tells how and which data to retrieve / store in and from Database Tables.