All articles: Transaction Control Language (TCL)

Checkout our self-help content, created by our top Experts!
ACID Properties in SQL Server – Querychat
This article explains the concept of ACID properties and how they are implemented in SQL Server database. Brief explanations on the concept and an example of basic transaction are also covered here. ACID is a common acronym in SQL worlds which stands for “atomicity, consistency, isolation, durability.” These four words...
How to Set Isolation Level in SQL Server – Querychat
Isolation is one of the listed ACID properties. It refers to the extent to which the data can go wrong for the sake of database performance in concurrent transactions. This article explains the various isolation levels in SQL Server database and the syntax that we can use to configure the...
How to change settings with the Alter User statement in Oracle – Querychat
ALTER USER statement is used to change the properties of an existing user. Some of the most important settings that this statement can change are the user’s password, assigned tablespace, space quota, profile, role, and locking/unlocking accounts. Keep in mind that there will be restrictions on the use of this...
Using Lock Hints in SQL Server – Querychat
Locking hints in SQL Server are included in the general category of table hints that specified in the FROM clause, after the name of the table to which should be applied WITH([HINTS]). It is used to ensure data consistency and control concurrency in the Database table. The article explains how...
Lock Table In MySQL – Querychat
MySQL allows access limitation by using LOCK TABLE, READ, WRITE, UNLOCK TABLE.  Simultaneous access to the client database can cause various errors and damage interaction among the users. In this article, we observe locking mechanisms for various purposes. SYNTAX Table locking provides the ability of simultaneous reading of table content...
MySQL transaction: BEGIN, COMMIT and ROLLBACK – Querychat
When you need to ensure an “all or none” execution while executing a set of statements in MySQL, then you need to look into Transactions. MySQL Transactions help in making sure that the database never contains the result of a partially completed operation (‘set of statements’ ->  ‘operation’). MySQL Transaction...
Error Handling in SQL Server using TRY and CATCH – Querychat
SQL Server provides the ability to handle errors by using the TRY…CATCH block. This mechanism can help us catch the errors in our Transact-SQL (T-SQL) code during execution. We can then change the flow of our code in response to error conditions. Syntax BEGIN TRY       { sql_statement | statement_block...