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

  ERROR: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.) …

With the Update Statement, we can update records in a table in the database. The most important thing to note when running this command is …

  The DDL command cannot be executed directly with the database link on the remote database. If it is run, it will cause the error …

  We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of reorganizing the indexes. I will …

  We use the Select Into Statement to export the data in a table to another table. You can see a few examples below. First, …

We use the Insert Into Statement to add data to a table. We can use the Insert Into Statement in a number of different ways. …

We use the Select statement to read data from the database. If we want to read the specific columns in the table, we need to …

  ERROR: Msg 2786, Level 16, State 1, Procedure sp_estimate_data_compression_savings, Line 20 The data type of substitution parameter 3 does not match the expected type …

  It is possible to define the email notification for the scheduled job. An e-mail can be sent when a job-related event occurs. The following …

  DBCC CHECKCONSTRAINTS checks the consistency of a specified constraint, or all constraints in a table.   So what is Constraint? Constraints are the restrictions …