Monthly Archives: May 2011

ACID Rules in Sql Server

ACID Rules This article will tell about the ACID Rules in SQL Server. 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 … Continue reading

Posted in SQL ACID Rule, SQL Server | Tagged | Leave a comment

DML, DDL, DCL, TCL in SQL Server

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 … Continue reading

Posted in SQL DDL, DML, DCL, TCL, SQL Server | Tagged | 32 Comments