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

  When reading data from the database, we can use GROUP BY clause when we want to group data and process on the groups we …

  I would like to talk to you about a new Built-in Function, CONCAT, that comes with SQL Server 2012. As you know, before SQL …

  ERROR: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) EXPLANATION: I received an error message when I wanted to import a …

  Oracle Flashback Query allows us to query as much as possible of the past committed data. We can query the data in the past …

We perform maintenance operations in SQL Server using Maintenance Plan. In this article, we will create a maintenance plan for differatial backup. I will share …

  With Order By Clause, you can sort the records returned as a result of the Select statement as ascending or descending according to the …

  We use WHERE clause to filter when reading, updating, and deleting data from a table. If we run select, Update, or delete statements without …

  When reading data from tables, we may need to give different names to tables and columns. We can do this by defining alias to …

  With the Merge Statement, we can run INSERT, UPDATE, and DELETE commands at one time to synchronize two tables of the same structure. First, …

ERROR: [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (DisableAgentXPs) EXPLANATION: You may experience …