This section is about SQL Server scripts common errors. The articles show some SQL scripts, tips, tricks, and workarounds on how to fix these errors.
The most common errors are about SQL Server objects that does not exist of because of permissions. But also about data conversions causing overflow, primary key, foreign key and violation of unique key constraint errors.
How to avoid the SQL error Cannot drop the database because it is currently in use ? It is possible to manage SQL databases with scripts or via the various windows of SQL …
How to avoid the SQL Server Truncate Table Error Cannot find the object? In SQL Server, to clear the full content of a table, the fastest way is to run a truncate Table …
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 …
With SQL Server, how to avoid this error : “Arithmetic overflow error converting expression to data type int”. Let’s insert some data into a table using a stored procedure for example. Facing this …
How to convert XML into NVARCHAR with SQL Server? To avoid the SQL Server error conversion from XML to NVARCHAR. The exact message is “Implicit conversion from data type xml to nvarchar is …
How to insert or update data in an SQL Server table with a simple query? Here are two simple solutions to execute an update or insert and avoid errors. The SQL Server 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 …
2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.
