When I tried to create a new table in SQL Server Management Studio (SSMS) 2014, I encountered the following error: I checked the SQL Server version using the select @@version command. I found out that it was 2019, which is different from the SSMS 2014. The error message appeared because the SQL Server version and […]
The backend version is not supported to design database Read More »
SQL SERVER has GENERATE SCRIPT command can export vendor’s database schema and data to the client’s SQL SERVER. Besides, GENERATE SCRIPT also provides various customized options. For example, you can check whether the client’s SQL Server already has the same schema table compared to the vendor’s. You can also choose whether you just want to
SQL performance is always a key issue that every DBA faces. This article introduces five ways for improving SQL performance. If subquery is a parameter, then use EXISTS instead IN If you use subquery as a parameter, it is better that you us EXISTS than IN even these two statements return same result, the
When you are familiar with CASE, you can make your SQL statement more flexible and reduce redundant semantics. CASE can be categorized into two cases. One is simple case CASE WHEN condition THEN result [WHEN···] [ELSE result] END; and the other one is searched case CASE expression WHEN value THEN result [WHEN···] [ELSE