SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.

Archives: May 2011

ACID Rules in Sql Server

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…

Read more

1 comments, 3,557 reads

Posted in Vivek's SQL Notes on 28 May 2011

DML, DDL, DCL, TCL in SQL Server

Different Types of Sql Statements:-

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

Read more

0 comments, 11,277 reads

Posted in Vivek's SQL Notes on 28 May 2011