Shulou(Shulou.com)06/01 Report--

Problem 1: VS2017 using the old version of mdf data file cannot be imported correctly

When using VS2017, you need to import some mdf files, such as Microsoft Northwind. When importing, the system will prompt:

After clicking upgrade, it will appear again.

If you install the full version of SQL, it's easy to do (I didn't install it, didn't try it, it should be easier to upgrade).

At the same time, the full version of SQL can also execute the corresponding SQL query to create the sample database. So how do you use a file with the suffix SQL to create a database in Localdb?

The specific steps are as follows:

1. In SQL Server object Explorer, select the database folder (the gray line), right-click, select create a new database, and enter the name of the database you want to create, such as test, in the pop-up dialog.

two。 Right-click on the newly created database and select New query. Next, VS2017 will automatically set up a query window. You just need to open the SQL file that created the database, copy the contents, click to execute, and set up the database.

Question 2: the database established by this method has garbled codes when querying Chinese.

The reason for this problem is that the default language ordering of Localdb is different. Follow these steps:

Right-click on the database folder above, select New query, and use the following statement in the query:

Create database test2

COLLATE Chinese_PRC_CI_AS

Click execute again, and the corresponding database can be established.

At this time, click the query on this database, enter the corresponding SQL statement in the new query window to complete the database construction operation, and the Chinese query can become normal.

I beg your pardon for the messy writing.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.