MySQL function to calculate the distance between two latitude and latitude pairs

Selec All Code:1 2 3 4 5 6 7 8 9 10 CREATE DEFINER=`root`@`localhost` FUNCTION `FIND_DISTANCE`(`src_latitude` FLOAT,`src_longitude` FLOAT, `dest_latitude` FLOAT,`dest_longitude` FLOAT) RETURNS INT(11) BEGIN /* This function takes four parameterss, two sets of latitude and latitude pairs and returns the distance between them in miles.   Example use SELECT * , FIND_DISTANCE(home_latitude, home_longitude, 52.5, -1)…

Open Windows Firewall Ports for SQL Server

http://blogs.msdn.com/b/jorgepc/archive/2009/08/25/open-firewall-ports-for-sql-server-the-easy-way.aspx @echo =========  SQL Server Ports  ===================  @echo Enabling SQLServer default instance port 1433  netsh firewall set portopening TCP 1433 “SQLServer”  @echo Enabling Dedicated Admin Connection port 1434  netsh firewall set portopening TCP 1434 “SQL Admin Connection”  @echo Enabling conventional SQL Server Service Broker port 4022   netsh firewall set portopening TCP 4022 “SQL Service Broker” …