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.