MSSQL

  When filtering through the Where Clause during data reading from the database, the IN operator can check whether the column is within certain values. …

  When reading data from the database with Between Operator, we can specify a range for the data we filter in WHERE Clause. Let’s make …

ERROR: Error: Microsoft ODBC Driver 11 for SQL Server : Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only …

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

With Distinct Clause, you can return only one of the recurring records as a result when reading data from the table. In other words, if …

  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 …

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 …