SQL Server Spatial TSQL Stored Procedures

$27.26 (inc. GST Australia)

Category: Tags: , , , ,

Description

Spatial Companion For SQL Server Spatial (SC4SSS) 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 ofLinear Referencing System (LRS) functions.

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

SQL Server Spatial Code Documentation
SQL Server Spatial LRS Code Documentation

Here is a summary of the number of functions in the SC4SSS 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','lrs','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 2
LRS FUNCTION SCALAR 36
GENERAL PROCEDURE SCALAR 1
GENERAL FUNCTION TABLE 19
GENERAL FUNCTION SCALAR 111
TOTAL: 169

A donation of $45 for my effort can be viewed as being $45 / 196 = 23 cents per function!

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

CATEGORY/FUNCTION (Minimum SQL Server Version)

General Functions

Linear Referencing System Functions

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.

Reviews

There are no reviews yet.

Be the first to review “SQL Server Spatial TSQL Stored Procedures”

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

Related products