Posted on
Mar 17, 2010
under T-SQL Programming
| 7542 views
Calculation of geographical distance is a very important utility function in GPS related procedures. The Haversine formula is used commonly for this. The haversine formula is an equation important in navigation, giving great-circle distances between two points on a sphere from their longitudes and latitudes. This actually gives the shortest distance between two points, assuming the globe as a clean globoid sphere with no obstacles between the points.
|
Posted on
Mar 17, 2010
under T-SQL Programming
| 18280 views
As you parse the UserAgent string in the server-side VB.NET or C#.NET code, it is possible to parse it using T-SQL programming. This would be extremely useful when your web application is more SQL Server dependant - having most of the business logic as stored procedures and functions. The only difference here is, as in ASP.NET, the UserAgent string is not accessible directly inside T-SQL context, but you need to pass the string from your ASP.NET calling method as a parameter to your stored procedure query.
|