How to find nearest location using latitude and longitude from sql

Table Strcture :-

Create table tbl_locations(Id int identity(100,1) primary key,Name varchar(100),Address varchar(200),Latitude varchar(50),Longtitude varchar(50)

NOTE - Here latitude = 12.994267 & longitude = 77.672940. So you just pass your own.

Select Query

SELECT Id,Name,( 3959 * acos( cos( radians(12.994267) ) * cos( radians( Latitude ) ) * cos( radians( Longtitude ) - radians(77.672940) ) + sin( radians(12.994267) ) * sin( radians( Latitude ) ) ) ) AS Distance FROM tbl_locations ORDER BY Distance

How to find current location Latitude & Longitude based on the IP-address using JavaScript

<script language="JavaScript" src="http://j.maxmind.com/app/geoip.js"></script>
 

<br>City:
<script language="JavaScript">document.write(geoip_city());</script> 

<br>Country Code:
<script language="JavaScript">document.write(geoip_country_code());</script>
<br>Country Name:
<script language="JavaScript">document.write(geoip_country_name());</script>
<br>Region Name:
<script language="JavaScript">document.write(geoip_region_name());</script>

 <br>Postal Code:
<script language="JavaScript">document.write(geoip_postal_code());</script>

 <br>Latitude:
<script language="JavaScript">document.write(geoip_latitude());</script>
<br>Longitude:
<script language="JavaScript">document.write(geoip_longitude());</script>