BEGIN TRANSACTION;
INSERT INTO SP RELATION {S# S#(‘S5’), P# P#(‘P1’),
QTY QTY(1000)}};
IF any error occurred THEN GOTO UNDO; END IF;
UPDATE P WHERE P# = P#(‘P1’)
TOTAL:=TOTAL + QTY(1000);
IF any error occurred THEN GOTO UNDO; END IF;
COMMIT;
GOTO FINISH;
UNDO: ROLLBACK;
FINISH: RETURN; 
Read Sav_Amt
Sav_Amt := Sav-Amt - 500
if Sav-Amt <0 then do
put (“insufficient fund”)
rollback
end
else do
Write Sav_Amt
Read Chk_Amt
Chk_Amt := Chk_Amt + 500
Write Chk-Amt
put (“transfer complete”)
End transaction tx_begin();
execute T1 //at site D
execute T2 //at site C
Execute T3 //at site B
…
tX_commit (); begin transaction();
s1;
sp1:= create savepoint(0);
s2;
sp2:= create savepoint(0);
if (condition)
rollback (spi);
…
…
commit Alter table, Create, delete, insert, open, drop, fetch, grant, revoke, select, truncate table, update
Set implicit_transaction on
SET TRANSACTION READ ONLY
SET TRANSACTION READ WRITE
READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE
Garbage Collection
string message = "Hello World!";
#include <stdio.h>
#include <stdlib.h>
void printReport(int* data)
{
printf("Report: %d", *data);
}
int main(void)
{
int *myNumber;
myNumber = (int*)malloc(sizeof(int));
if (myNumber == 0)
{
printf("ERROR: Out of memory");
return 1;
}
*myNumber = 25;
printReport(myNumber);
free(myNumber);
myNumber = NULL;
return 0;
} using System;
public class Program
{
public static void Main()
{
int myNumber = 25;
PrintReport(myNumber);
}
private static void PrintReport(int number)
{
Console.WriteLine($"Report: {number}");
}
} 
Chapter 1: Introduction
Chapter 2: Collecting Requirements
Chapter 3: Processing Incoming E-mail
Chapter 4: Managing Requirements
Chapter 5: Supporting Discussions
Chapter 6: User Stories
Chapter 7: Project Backlog
Chapter 8: Iteration Backlog
Chapter 9: Burndown Charts
Chapter 10: Getting Organized
Chapter 11: Creating Test Cases
Chapter 12: Reporting Defects
Chapter 13: Testing Metrics
Chapter 14: Workflow Tasks
Chapter 15: State Machine Workflows
Chapter 16: Creating Custom Forms
public interface IMyOperation
{
void DoIt();
} public void DoIt()
{
Console.WriteLine( "this is main block of code" );
} public class Logger
{
const string path = @"D:\Log.txt";
public static void WriteToFile( string methodName )
{
object lockObject = new object();
if ( !File.Exists( path ) )
{
File.Create( path );
}
lock ( lockObject )
{
using ( TextWriter writer = new StreamWriter( path , true ) )
{
writer.WriteLine( string.Format( "{0} at {1}" , methodName , DateTime.Now ) );
}
}
}
} public class LogHandler : ICallHandler
{
public IMethodReturn Invoke( IMethodInvocation input , GetNextHandlerDelegate getNext )
{
Logger.WriteToFile( input.MethodBase.Name );
var methodReturn = getNext()( input , getNext );
return methodReturn;
}
public int Order { get; set; }
} var methodReturn = getNext()( input , getNext );
public class LogAttribute : HandlerAttribute
{
public override ICallHandler CreateHandler( Microsoft.Practices.Unity.IUnityContainer container )
{
return new LogHandler();
}
} var unityContainer = new UnityContainer();
unityContainer.AddNewExtension<Interception>();
unityContainer.Configure<Interception>().SetDefaultInterceptorFor<IMyOperation>( new InterfaceInterceptor() );
unityContainer.RegisterType<IMyOperation, MyOperation>(); var container = new UnityContainer(); container.RegisterType<Book , Book>(); container.AddNewExtension<Interception>(); var policy = container.Configure<Interception>().SetDefaultInterceptorFor<Book>( new VirtualMethodInterceptor() ).AddPolicy( "MyPolicy" ); policy.AddMatchingRule( new PropertyMatchingRule( "*" , PropertyMatchingOption.Set ) ); policy.AddCallHandler<Handler.NotifyChangedHandler>();