Datetime manipulation examples..

to get the date in number with format yyyymmdd .
CAST(CONVERT(VARCHAR, DATEADD(DD, -1, GETDATE()), 112) AS INT) 

Transanctions in sql

Following is the code to write transactions in sql.