Transactions
In SQL Server 2008, a transaction is a set of SQL statements that are executed as a single unit of work. Transactions are used to ensure data integrity and consistency by allowing a set of operations to be either completed entirely or rolled back completely in the event of an error or interruption.
SQL Server 2008 supports two types of transactions: explicit transactions and implicit transactions.
Explicit transactions require the use of transaction control statements such as BEGIN TRANSACTION, COMMIT TRANSACTION, and ROLLBACK TRANSACTION to start, commit, or rollback a transaction explicitly.
Implicit transactions are automatically started and committed by SQL Server without the need for transaction control statements. This behavior is controlled by the SET IMPLICIT_TRANSACTIONS ON or OFF statement.
In addition to transaction control statements, SQL Server provides transaction isolation levels to control the visibility and locking behavior of transactions. The isolation levels include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. Overall, transactions are a fundamental concept in SQL Server 2008 that ensure data consistency and reliability.
Apply for SQL Server 2008 Certification!!
https://www.vskills.in/certification/certified-sql-server-2008-programmer
