Yearly Archives: 2011

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 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 »

ACID Rules in Sql Server

By | May 28, 2011

ACID Rules ACID Rules:- It is a concept for evaluation of databases and their architecture. A:- (Atomicity) – Atomicity  states the principle of  All or none. This means that either all the SQL Statements within the transaction will be executed or no Sql statement will be executed. C:- Consistency:- Consistency states that only valid data will… Read More »

DML, DDL, DCL, TCL in SQL Server

By | May 28, 2011

Different Types of Sql Statements:- DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements Select :- This Sql Statement is used to extract the data from one or combination of tables Update:- This Sql Statement is used… Read More »