You receive this error when you try to convert a string that is a not compatible with the datetime data type to a datetime. …

  We use the AVG function to obtain the average value of the specified column. Its one of the most used SQL Server functions. Let’s …

  The password of Oracle database users is usually set to the same as the user name. Or passwords are set very simply. That means …

  We can capture Query Timeouts by using SQL Server Extended Events Session. Right click on Management-> Extendend Event-> Sessions on SSMS and select new …

  We send a dataset to a function by grouping it with the Partition By statement int the OVER Clause. We sort the groups by …

  Constaint allows us to set specific rules for data in a table. For example; to make sure that the data in a column is …

  We can use “NOT NULL Constraint” to prevent values in a column from containing null data. Example: In the following example, when creating a …

  Result Cache is the memory space in the shared pool area within the Shared Global Area (SGA). In this memory area, the database query …

In some cases, SSMS (SQL Server Management Studio) is not installed on the server and you may need to connect to SQL Server from the …

We use the LIKE operator with WHERE clause. I suggest you read the following article about WHERE clause. “Where Clause in SQL Server and SQL …