SBO | nPoint SQL

DROP TYPE N_Punkt
GO
DROP ASSEMBLY [N_Punkt_a]
GO
CREATE ASSEMBLY [N_Punkt_a]
AUTHORIZATION [dbo]
FROM 'C:\e740\repos\Funkcje\NPoint\NPoint\bin\Debug\NPoint.dll'
WITH PERMISSION_SET = SAFE
GO
CREATE TYPE dbo.N_Punkt
EXTERNAL NAME N_Punkt_a.nPoint;

DECLARE @a N_Punkt, @b N_Punkt;
SET @a = CAST('1.2, 3, 7.8, 8' AS N_Punkt)
SET @b = CONVERT(N_Punkt, '4, 7, 4, 6')

SELECT @a, @b,
@a.ToString(),
@a.SIZE,
@a.Coordinates,
@a.Coordinate(2),
@a.Przesun('2, 4, 2, 5'),
@a.PrzesunP(@b),
@a.DistanceFromCoordinates('1, 2, 3, 4'),
@a.DistanceFrom(@b),
@a.DistanceFrom(@b.Przesun('2, 4, 2, 5'))

SELECT @a.ToSpatial()
UNION ALL
SELECT @b.ToSpatial()

SELECT @a.ToSpatialWithR(.1)
UNION ALL
SELECT @b.ToSpatialWithR(.1)