SQL Server Errors

SQL Server Database does not exist sp_MSforeachdb

With SQL Server, when using the sp_MSforeachdb system stored procedure, the system displays this error “Database does not exist. Make sure that the name is entered correctly.” . The stored procedure displays the error because the database tries to access a database that does not exist in your SQL Server

SQL Server Errors

Arithmetic overflow error converting expression to data type int

With SQL Server, let’s insert some data into a table using a stored procedure for example. Facing this SQL Server error message can be disturbing “Arithmetic overflow error converting expression to data type int”. Even if SQL conversion errors are very classical ones, finding the solution and best practices to

SQL Server Errors

SQL Server Implicit conversion from data type XML to nvarchar

How to convert XML into NVARCHAR with SQL Server? To avoid this error “Implicit conversion from data type xml to nvarchar is not allowed. Use the CONVERT function to run this query.”. With SQL Server data, it is useful to combine numerical columns, alphanumeric strings and XML typed columns.  In

SQL Server Errors

Invalid object name SQL Server CTE Error

How to execute multiple SELECT queries on the same CTE? As a reminder, a CTE is a temporary object that only exists between its creation and the first time it’s used. It means it’s deleted right after the first query ran against the CTE. Indeed when querying the second time