Monthly Archives: May 2011

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 »