mySQL syntax - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

mySQL syntax

Author

Topic

sg2255551
Constraint Violating Yak Guru

274 Posts

Posted - 2012-12-04 : 20:30:34

hi

I have this sql syntax in MySQL. What is equivalent for MSSQL 2008? Thanks

$lat = -31,52;
$lon = -68,52;

$multiplier = 112.12; // use 69.0467669 if you want miles
$distance = 10; // kilometers or miles if 69.0467669

$query = "SELECT *, (SQRT(POW((lat - $lat), 2) + POW((lng - $lng), 2)) * $multiplier) AS distance FROM routes WHERE POW((lat - $lat), 2) + POW((lng - $lng), 2) < POW(($distance / $multiplier), 2) ORDER BY distance ASC";

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-04 : 21:13:49

[code]
Declare @lat float,@lon float,@multiplier float,@distance float

Set @lat = -3152
Set @lon = -6852
Set @multiplier = 112.12
Set @distance = 10

SELECT *,
(SQRT(POWER((lat - @lat), 2)) + POWER((lng - @lon), 2)) * @multiplier) AS distance
FROM routes
WHERE POWER((lat - @lat), 2)) + POWER((lng - @lon), 2)) < POW((@distance / @multiplier), 2)
ORDER BY distance ASC[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources