20 million open room data how to open?

20 million open room data download, found is a bak file, this bak file is the SQL database backup file, to use SQL Restore and then you can query.

Find the file you need

Note that the decompression is 7gb+.

1. Download SQL Server Express (with manager)

2, the installation of the "New Installation"

3. Open SQL Server Management Studio

4, right click Red Circle "Database"-----"RESTORE Database"

Determine import---Waiting to complete

And then this database will appear.

Right button, click on the top 1000 lines, the right side will appear as shown

You can see that with this code you can display 1000 lines of information

So let's get rid of that top 1000.

Become like this

And then the most critical

Join at the bottom

Click "Execute"

The results will appear below.

I use SSD to search, about 10 seconds to complete the retrieval, so you weigh it yourself.