SQL Server Spatial TSQL Stored Procedures
$9.95 (inc. GST Australia)
This product is a collection of powerful TSQL functions for use with SQL Server Spatial.
Spatial Companion For SQL Server Spatial is a complete collection of TSQL functions and procedures for a developer using SQL Server Spatial (various editions).
The TSQL functions include the all the base functions and a full set of Linear Referencing System (LRS) functions.
The documentation for these functions is hosted on this website at the following two locations:
Here is a summary of the number of functions in the package.
select SUBSTRING(f.routine_schema,1,10) as routine_schema, f.routine_type, ISNULL(f.data_type,'TOTAL:') as data_type, f.count_by_type from (select r.routine_schema, r.routine_type, case when r.data_type = 'TABLE' then 'TABLE' else 'SCALAR' end as data_type, count(*) as count_by_type from [INFORMATION_SCHEMA].[ROUTINES] as r where r.routine_schema in ('dbo','lrs','cogo') and r.specific_name not like 'sp%' and r.specific_name not like 'fn%' group by ROLLUP( r.routine_schema, r.routine_type, case when r.data_type = 'TABLE' then 'TABLE' else 'SCALAR' end ) ) as f where f.routine_schema is null or ( f.routine_schema is not null and f.data_type is not null ) order by f.routine_schema desc,f.routine_type, f.count_by_type; GO
A donation of $45 for my effort can be viewed as being $29.99/ 232 = 13 cents per function!
A description of each of the available functions is available in the online help (see above).
If a request for new function is received, and implemented, the function will be provided for the original purchaser and any future persons who download the package.
The license under which this code is distributed is the MIT license. However, there are other requirements that are outline in the page on Software Philosophy.