Tuesday, April 12, 2011

What is a transaction and what are ACID properties?

A transaction is a logical unit of work in which, all the steps must be performed or none. ACID stands for Atomicity, Consistency, Isolation, Durability. These are the properties of a transaction. For more information and explanation of these properties, see SQL Server books online or any RDBMS fundamentals text book.
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Add two integers together
    Module Tester     Sub  Main ()        Dim  firstNumber, secondNumber  As  String        Dim  number1, number2, sumOfNumbers  As  Intege...
  • Turn Explicit off to use variable without declaration
    Option Explicit Off Module Module1      Sub  Main ()          EmployeeName =  "Buddy Jamsa"          EmployeePhoneNumber =  ...
  • Cause compiler error when Option Strict On
    Module Module1         Sub  Main ()      Dim  AnInt  As  Integer =  5      Dim  ALong  As  Long =  7      ALong = AnInt      'ca...