It has always been possible to work with geospatial data in SQL Server using built-in geometric and trigonometric functions such as SIN(), COS(), and ACOS(). However, SQL Server 2008’s spatial data types made complex spatial queries a lot more accessible to those of us who don’t remember what a cosine actually is. In this article, I will show you how to use these built-in functions within a user-defined function (UDF) to illustrate the traditional method of calculating ...
Buy This Project Plan Now!
This content is part of the Migrating to SQL Server 2008 & 2008 R2 Project Plan.
Purchase this project plan to receive:
- Step-by-step guidance for managing your project, start to finish
- Tested advice for preparing for and completing your project
- Insights to help you avoid common pitfalls and traps