I once thought about recording data while reading data cyclically, but the efficiency is not as good as calling functions directly in SQL.
Create Function [DBO]. [fngetdistance] (@ latbegin real, @ lngbegin real, @ latend real, @ lngend real) returns float asbegin -- distance (meters) declare @ distance real declare @ earth_radius real set @ earth_radius = 6378137.0 -- Earth radius declare @ radlatbegin real, @ radlatend real, @ radlatdiff real, @ radlngdiff real set @ radlatbegin = @ latbegin * Pi ()/180.0 set @ radlatend = @ latend * Pi () /180.0 set @ radlatdiff = @ radlatbegin-@ radlatend set @ radlngdiff = @ lngbegin * Pi ()/180.0-@ lngend * Pi () /180.0 set @ distance = 2 * asin (SQRT (Power (sin (@ radlatdiff/2), 2) + cos (@ radlatbegin) * Cos (@ radlatend) * power (sin (@ radlngdiff/2), 2) set @ distance = @ distance * @ earth_radius return @ distanceendgo
You only need to call the SQL command to display it.
Nearby marketplace-successful record of a codoon