You can use the bcp or bulkinsert command in SQLSERVER to import the dat file to the data table.

Source: Internet
Author: User
Using the bcp command or bulkinsert command in SQLSERVER, you can also import the dat file into the experiment environment of the content under the data table. I saw two articles in the garden before I made it in SQLSERVER2005 # read pure IP database QQWry. dat reads region information, C # How to read pure qq ip database, and writes a lot of C # code to read pure

Using the bcp command or bulkinsert command in SQLSERVER, you can also import the dat file into the experiment environment of the content under the data table. I saw two articles in the garden before I made it in SQLSERVER2005 # read pure IP database QQWry. dat reads region information, C # How to read pure qq ip database, and writes a lot of C # code to read pure

You can use the bcp or bulkinsert command in SQLSERVER to import the dat file to the data table.

The experiment environment of the following content I made on SQLSERVER2005

I saw two articles in the garden.
C # Read the pure IP database QQWry. dat to obtain region information

C # How to read QQ pure IP database

I wrote a lot of C # code to read data from the pure ip database. The pure ip address database is actually a dat file, website space, and how complicated the code is to be used, block operations, shift

In case the database changes, the Code cannot be used.

I found that QQ also uses this IP address database, so QQ is also constantly updated and upgraded, replacing this dat file, Hong Kong server, in order to accurately display your login address

Pure IP Address Database: qqwry. dat

Download pure IP address database:

Convert the starting IP address in the byte block in the index area to the Long array [] BlockToArray (byte [] ipBlock) 6 {[ipBlock. length/7]; 8int ipIndex = 0; [8]; 10for (int I = 0; I <ipBlock. length; I + = 7) 11 {12Array. copy (ipBlock, I, temp, 0, 4); 13 ipArray [ipIndex] = BitConverter. toInt64 (temp, 0); 14 ipIndex ++; 15} 16 return ipArray; 17}, US space

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.