Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

If the condition in the IF block is provided, operations between the BEGIN and END blocks are performed. If the condition in the IF block …

  If the condition in the “IF” block is provided, we perform operations between the “BEGIN” and “END” blocks. You can use it as follows. …

  When we want to add data to a table, we get this error if the size of the column in the table is smaller …

  It is possible to export the data in tables in the database in csv format depending on a specific condition. We can use the …

If you are using a consolidated SQL Server environment, there is more than one database and login on an instance. When the logins connect to …

  If there is a variable in the script we run and we have not declared this variable, we will get this error. For example, …

  Sometimes, we can receive the below error. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the …

  It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from …

  DPM (Data Protection Manager) is Microsoft’s software for backup. Before reading this article, I recommend you to read other articles related to DPM on …

  With UNION and UNION ALL Opertors, we can merge multiple sql statement’s result in a single result set. When we merge two SQL statements …