Question

I have the below code in SQL. This is called by passing a geometry object, as in dbo.MakeValidGeographyFromGeometry(geom):

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER FUNCTION [dbo].[MakeValidGeographyFromGeometry](@inputGeometry [geometry])
RETURNS [geography] WITH EXECUTE AS CALLER
AS 
EXTERNAL NAME [SQLSpatialTools].[SQLSpatialTools.Functions].[MakeValidGeographyFromGeometry]

我们常常在地貌方面有错误,导致这一功能产生问题。因此,我要更新“电离层”参数。我知道该法典更新了地貌,但没有知道如何在这里执行。

In a function like this, how can we update the parameter being passed through?

Answer 1

由于不能把性病和组装放在一种功能中,即建议建立一种称为你的组装功能的总结功能。总结职能应有原始名称,以避免中断和改写。

The basic steps are:

Create a new assembly function called MakeValidGeographyFromGeometryInternal that is a copy of the current assembly function. Make sure to take note of the existing permissions so you can transfer them properly
Drop the current assembly function. This is needed because usually SQL Server disallows changing the function "type" by ALTER.
Create a wrapper function called MakeValidGeographyFromGeometry that does whatever processing you need and then calls MakeValidGeographyFromGeometryInternal. Make sure to take care of permissions needed if any.

This should allow you to keep the calling code as it was.

友情链接