Understanding Database Stored Procedures

What is a Stored Procedure? A stored procedure is a database object that contains one or more SQL statements. In this article you will get an idea on how to create and use stored procedures and also highlighted on how… Continue Reading


How to use the EXCEPT and INTERSECT operators in SQL Server 2005

  INTRODUCTION The EXCEPT and INTERSECT operators are new operators that have been introduced in SQL Server 2005. Returns distinct values by comparing the results of two queries. EXCEPT returns any distinct values from the left query that are not… Continue Reading


Creating and working with Views in a Database

  Introduction Views are generally used to focus, simplify, and customize each user’s perception of the database. You can use a view as a security mechanism by allowing a user to access data through the view without granting the user… Continue Reading


Joins in SQL Server 2005

  In this article, we are going to discuss SQL Server Joins. A join is used to combine columns from two or more tables into a single result set. To join data from two tables you write the names of… Continue Reading