All articles: Transaction Control Language (TCL)

Checkout our self-help content, created by our top Experts!
What is the DBCC OPENTRAN command – Querychat
In this article, we will find out what is the DBCC OPENTRAN command in SQL Server and what its main purpose is. What is more, we will look at the examples with screenshots. The DBCC OPENTRAN command syntax When we work with the transaction log, we may end up having...
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...
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...