In this article we are going to discuss Stored Procedures.

Triggers are special kind of Stored Procedure that executes automatically when a user tries to modify database.

In this article I will demonstrate how to use Temporary Tables in SQL.

In this article you will learn how too create a Stored Procedure using a C# CLR Project.

DML trigger statements use two special tables: the deleted table and the inserted tables. SQL Server automatically creates and manages these tables.

Article helps to show basic queries to retrieve database related information’s.

In this article we will see how to make bulk operation in SQL Server.

Microsoft SQL Server 2000 is an application used to create computer databases for the Microsoft Windows family of server operating systems. Microsoft SQL Server provides an environment used to gene...

This article will explain how to delete and update Child Table records implicitly when updating or deleting a Parent Table.

By this article I am trying to show you the joins in a different way i.e. in math terms by the sets as well as the query which will give you the return in one single click of Execute in Management ...

This article describes parameter sniffing and performance in SQL Server 2005.

A View is virtual; the data from a View is not stored physically. It is a set of queries that, when applied to one or more tables, is stored in the database as an object.

Here I am demonstrating how to simply configure networking connectivity in SQL Server 2005.

This article is a brief Introduction to SQL Server 2005.

In this article we will see how to create a full text search index for a SQL Server database for effective searching.

In this article, we will learn how to handle the exception in SQL server and store the error log in a SQL server table for reference.

Computed Columns remain to be an unused feature in SQL Server. But if efficiently used, they can give us good flexibility and speed over the traditional approach.

Ann introduction to Joins in SQL Server.