Properties of Transactions

Properties of Transactions:

Transactions have the following four standard properties, usually referred to by the acronym ACID.

The most popular T-SQL statement is the stored procedure, which is a compiled and stored T-SQL code.

• Atomicity − ensures that all operations within the work unit are completed successfully. Otherwise, the transaction is aborted at the point of failure and all the previous operations are rolled back to their former state.
• Consistency − ensures that the database properly changes states upon a successfully committed transaction.
• Isolation − enables transactions to operate independently of and transparent to each other.
• Durability − ensures that the result or effect of a committed transaction persists in case of a system failure.

• Sql -Stored procedure how to use

• Different Types of SQL Server Stored Procedures

• SQL-Create Stored Procedure in SQL Server:

• SQL Server -Create Stored Procedure with Parameter

• How to Create Sql Function,

• SQLInjection, prevent asp.net web application

• SQL Server- Database Backup and Restore History

• SQL Server -Create Stored Procedure with Parameter

• Sql server cursor declaration syntax example

• Sql server –Example of sql cursor with syntax

• Drop all Triggers belonging to any schema in SQL Server.

• SQL Server - Copy data from one database to another data base.