All articles: Data Control Language (DCL)

Checkout our self-help content, created by our top Experts!
Save points in SQL Server – Querychat
Going back to a previous state after an error occurs is functionality that SQL Server offers by default. This turns out to be a pretty handy tool in situations where unexpected errors occur.  A mechanism that allows us to do this is called a savepoint. This article elaborates on what...
Delaying T-SQL Code Execution using WAITFOR – Querychat
There are situations when we need to suspend the execution of a transaction, stored procedure, or a block of T-SQL commands for a fixed period of time or until a specific time. SQL Server allows us to do that through the use of the WAITFOR statement. In this article, we...
How to install ODBC driver 11 for SQL Server – Querychat
In this article, we will see step by step How to install ODBC driver 11 for SQL Server. Then we will create an ODBC data source for a SQL Server database. Step 1, download ODBC driver 11 for SQL Server The first step is to download the installer. We can...
@@ERROR: The Old-Style Error Handling – Querychat
Before SQL Server 2005, error handling generally involved checking the @@ERROR variable after every statement was executed. Then, the code would use the GOTO statements to point to an error handling block where, if an error has occurred, the process would be terminated, and the transaction rolled back. In this...
How to manage users in SQL Server – Querychat
In this article we will learn how to manage users in SQL Server, this means: get a list of users, add a new user, and delete a registered user. First, let's create an example database on which we will execute our examples: CREATE DATABASE MyDataBase GO USE MyDataBase GO Script...
Granting permissions in SQL Server – Querychat
By the end of this article, you will learn about the most important permissions within a SQL Server database, how they are split into server-level and database-level permissions. Also, you will learn how you can grant users access to different levels of permissions through either a visual interface provided by...
The most common Microsoft SQL Server errors – Querychat
In this article, we will learn why is it is important to fight with SQL Server errors and what are three the most common Microsoft SQL errors. Why do we need to handle errors in the code? During the SQL Server work errors can appear while entering the information in...
What is MySQL Message You Must Reset Your Password – Querychat
MySQL allows database administrators to apply password expiration policies for the database users. What happens if a user with an expired password tries to connect to the database is what we will discuss in this article. MySQL allows different behaviors based on system settings and based on the client trying...
How to manage users in MySQL – Querychat
In MySQL, we can define the access that users have, both at the database level and the table level. We can define what operations each user is allowed to perform per database and per table. We will learn how to do it in this article. How to create a user...
How to create a second instance of MySQL – Querychat
It is likely that at some point you needed to launch a second instance of the MySQL database on the same machine. In this article, we will see how to do it.  However, we are not going to install MySQL again. The idea is to use the resources of the...
1 2