Tag Archives: SQLServerPediaSyndication

SQL Triggers – An Introduction

By | November 10, 2011

Introduction Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute data modification commands (INSERT, DELETE and UPDATE) on the specified tables. Triggers are bound to specific tables. As per MSDN, triggers can be defined as the special kind of stored procedures. Before describing the types of triggers,… Read More »

Sql server Constraints – Primary Key, Foreign Key, Unique Key, Not Null, Check Constraints

By | August 19, 2009

A constraint is a property that is assigned to a column or a group of columns to prevent incorrect or corrupt data from entering into the tables. These constraints ensure the accuracy and reliability of the data into the tables. Let’s suppose we have two tables Employee and Department whose description is given below:- CREATE… Read More »