All articles: Data Control Language (DCL)

Checkout our self-help content, created by our top Experts!
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...
How to establish an ASP.NET trusted connection to SQL Server? – Querychat
Almost every ASP.NET application uses databases and the most common one to be used is SQL Server. In this article, we will discuss the means of web applications connecting to SQL Server. Common ASP.NET connection string mistake When we develop an application on ASP.NET that uses a database, we inevitably...
How to set up an ADODB connection to MySQL – Querychat
Before proceeding with the ADODB configuration, let's first know what ADODB is and how it can help us. ADODB stands for Active Data Object DataBase. And it is nothing more than an intermediate layer between PHP and the database managers. ADODB provides a series of commands to standardize the connection...
1 2