Query to Locate IP in Sql Server database From CSV?

Support on setups where you copy the hostip.info database locally.

Moderator: Moderators

Query to Locate IP in Sql Server database From CSV?

Postby ilg1976 on Thu Jul 19, 2007 3:05 am

Hi,

I am using the following query to lacate IP address. This is working correctly. But i am not sure.

Can any one check this 'n' tell me if this is the correct one?

SELECT C.COUNTRY, C.COUNTRYNAME, A.CITY, A.LAT, A.LONG
FROM IP_ALL A, IP_COUNTRY B INNER JOIN COUNTRY C
ON B.COUNTRYID = C.SID
WHERE B.IP = rootip AND A.IP >= rootip AND A.IP <rootip>= 3392726784 AND A.IP <= (3392726784 + 255);

My doubt is whether the query formed is the correct usage or not?

If anyone knows please reply. Also please answer my previous question/Topic "Duplicate Records in CSV".

Thanks,
Dhana
ilg1976
n00b
 
Posts: 2
Joined: Mon Jul 16, 2007 10:40 pm

The best departmental Store in UK

Postby seoceo2008 on Sun Jan 25, 2009 11:20 pm

The UK’s leading departmental store welcomes you at its outlet of various shopping and electronic stuff. These items are fashion, photography, electronics, jewelry, beauty products, watches, computer & IT, instruments, video games, house and home stuff, nursery, furniture, sports and fitness, garden and DVDs. These items are available at cheap prices and are reliable. This outlet has a lasting score of items. These items are masterpieces and cheap by any test. Therefore, shop-direct.com offers this opportunity for you to be part of the stylish world.
Most importantly Ugg Boots UK, Cameras UK, Electronics UK, Jewellery UK and Watches UK are available with best designs of today’s world. cheap Ugg Boots UK are stylish and trendy in such a way that that you will find yourself short to choose the best out of best because these shops have a reasonably outstanding variety. Cameras UK are better electronic devices which can provide you mega pixel ratio with best results. You may have never seen such variety of cameras anywhere which you can find over here at Shop-direct.com. This Cameras Uk are the best cameras available in the whole Europe at comparatively cheap prices. Similarly, this outlet also provides you a huge variety of electronics. Electronics UK at shop-direct include a significant variety on cheap prices. These electronics UK can be compared in quality and making with any other outlet’s electronic devices because we do not claim only but our products can tell you the very fact about.
However, not only the cameras UK, UggBoots UK and Electronics UK are available at affordable rates but our jewellery UK is also an outclassed invention in the field of ornaments. The jewellery UK can be shipped to anywhere easily at considerable rates and comparable prices. This jewellery UK has many designs according to the moving trends of world. These jewellery UK designs are different and unique. These jewellery UK ornaments are so carefully made that you can give them to your beloved ones as a different but beautiful piece of love.
However, besides these cameras UK, Ugg Boot UK, Electronics UK and Jewellery UK; watches Uk are also best wrist watches of all the times. This Watches UK are available at cheap prices which are parcels for the present new styles and old styles. This Watches UK are standard watches in the row of best wrist watches and wall clocks.
The whole major list such as Cameras UK, cheap Uggs UK, Electronics UK, Jewellery UK and Watches UK are the best choices with dashing variety. These items are in differentiating variety at cheap prices. These Ugg Boots UK, Cameras UK, Electronics UK, Jewellery UK and Watches UK are world class.
This outlet invites you to buy the best products of the century. These products can be obtained easily. You can buy whatever you want of them. These products can be got on cheap prices. These products such as Cameras UK, Ugg Boots UK, Electronics UK, Jewellery UK and Watches UK can be shipped overseas easily.
seoceo2008
n00b
 
Posts: 7
Joined: Tue Dec 30, 2008 6:38 pm


Return to Hostip.info database local copy support

Who is online

Users browsing this forum: No registered users and 2 guests

cron