Subscribe to this blog
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…
0 comments, 743 reads
Posted in Vivek's SQL Notes on 28 May 2011
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 to extract the data from one or combination of tables
0 comments, 1,521 reads
Posted in Vivek's SQL Notes on 28 May 2011