May 2011 - Technology with Vivek Johari

ACID Rules in Sql Server

May 28, 2011October 28, 2018 vivekjohariLeave a Comment

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 the transaction will be executed or no SQL statement will be executed. C:- Consistency:- Consistency […]

DML, DDL, DCL, TCL in SQL Server

May 28, 2011January 28, 2019 vivekjohari21 Comments

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 […]