All articles: General SQL

Checkout our self-help content, created by our top Experts!
How to Backup a Table in SQL Server – Querychat
Most often, backup seems to be needed for a complete database or specific information’s backupset. A major need that arises in this discussion is a single table backup. Sometimes, we are asked to take or provide only targeted table backup. In this article, we will be learning all those possible...
MS Access create tables and fields – Querychat
Every time we create a new database in Access, it automatically displays a new empty table, we can change the structure of this empty table, or we can also create a new table in the MS Access database. In this article, we will learn step-by-step on how to create a...
SQL Server resource database backup – Querychat
The resource databases are hidden databases that do not appear on a view in the SQL Server Management Studio (SSMS). And It will not be included when we are performing backups for all existing databases. The article will provide information on how to perform SQL Server backup for resources database...
What is MS Access DoCmd OpenForm Method – Querychat
In this article, we will discover what the MS Access DoCmd OpenForm method do, what its syntax and what variations of this method exist. MS Access DoCmd OpenForm syntax We use this method to open the forms in MS Access.  The syntax is:  DoCmd.OpenForm(TheForm, Show, QueryName, WhereWithoutWhere, InputMode, WindowsMode, OpenArgs)...
Practicing SQL and MySQL with online tests – Querychat
In this article, we will explore the different options that are available on the Web for measuring your knowledge in SQL, MySQL, and databases in general. We usually want to determine if we are capable of applying to different DBA certifications, but before we jump into that, we should be...
MySQL error code 1050 in CREATE TABLE statements – Querychat
MySQL Server logs store error messages that can come from the server-side to be sent to the client. One of the logs that originate on server-site has a symbol ER_TABLE_EXISTS_ERROR; it is an error 1050: Table already exists message. The article provides information on how to handle error code 1050...
MySQL semicolon – Querychat
For some common reasons that most SQL can implement semicolons because the ANSI or ISO standards require that statements be separated by semicolons in SQL. The MySQL semicolon is used to indicate the end of a query or just a delimiter. This article provides information about how to use MySQL...
MSSQL restore differential backup – Querychat
The SQL Server RESTORE DATABASE statement provides an option that allows us to restore a database with a differential backup process type. For restoring differential backup will be available and can be performed through SQL Server Management Studio (SSMS) and Transact-SQL. The article will explain how to restore a differential...
SQL Server Database Backup Encryption – Querychat
SQL Server database backup files that are created without encryption can be opened and easily read by using Windows Notepad to view or retrieve data in it. When data in the unencrypted backup file is restorable and used by other parties who are not responsible, it can cause a data...
MySQL show master-slave status – Querychat
The SHOW STATUS on the MASTER or SLAVEs MySQL can be useful for database replication that creates copies of the master database to the slave in realtime. By using the SHOW MASTER STATUS or SHOW SLAVE STATUS will help us to check or view the database replication status either on...
1 2 14 15