Tag Archives: SQLServerPediaSyndication

Isolation levels in SQL Server

By | August 19, 2012

Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved with the help of locks but what locks are needed and how they can be established is decided on the isolation level set on the database level. If low level of Isolation is set, it… Read More »

SQL Triggers – An Introduction

By | November 10, 2011

SQL Trigger 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… Read More »

SQL Server Functions- An Introduction

By | August 2, 2011

SQL FUNCTION: –    Function in a database can be defined as the code segment consisting of a logical group of SQL statements which takes some input arguments (if required), run in a sequential order and returns the output either in the form of a single value or in the form of a table.Through this… 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 »