SQL Server

How to display the SQL Server version with a query?

How to display the SQL Server version exact number with a simple SQL Server query? Using SQL Server Management Studio, to get the exact version of the SQL Server installation, it’s possible by using simple T-SQL queries.   For example, it’s very helpful to know the exact version of SQL

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