SQL Server Spatial TSQL BASE Edition

$25.00 (inc. GST Australia)

A set of spatial processing functions for SQL Server Spatial written in TSQL.

Description

SQL Server Spatial Base Edition is a collection of TSQL functions and procedures for a developer using SQL Server Spatial (various editions).

The documentation for these functions is hosted on this website at the following location:

SQL Server Spatial Code Documentation

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. If the request comes from someone who has not donated and downloaded the package, a request will be made to donate and download before the function is written.

Here is a summary of the functions in the base package.

select f.category,f.routine_type,
ISNULL(f.data_type,'TOTAL:') as data_type,
f.count_by_type
from (select case when routine_schema = 'lrs' then 'LRS' else 'GENERAL' end category,
routine_type,
case when data_type = 'TABLE' then 'TABLE' else 'SCALAR' end as data_type,
count(*) as count_by_type
from [INFORMATION_SCHEMA].[ROUTINES]
where routine_schema in ('dbo','cogo')
and specific_name not like 'sp%'
and specific_name not like 'fn%'
group by ROLLUP(
case when routine_schema = 'lrs' then 'LRS' else 'GENERAL' end,
routine_type,
case when data_type = 'TABLE' then 'TABLE' else 'SCALAR' end
)
) as f
where f.category is null
or ( f.category is not null
and f.data_type is not null
)
order by f.category desc,f.count_by_type;

category routine_type data_type count_by_type
LRS FUNCTION TABLE 1
LRS FUNCTION SCALAR 19
GENERAL FUNCTION SCALAR 111
TOTAL: 131

A donation of $25 for my effort can be viewed as being $25 / 131 = 19 cents per function!

A list of the available functions is summarised in the following list:

CATEGORY/FUNCTION (Minimum SQL Server Version)

General Functions

Reviews

There are no reviews yet.

Be the first to review “SQL Server Spatial TSQL BASE Edition”

Your email address will not be published. Required fields are marked *