TRY_PARSE使函数不确定

Question

我想使计算列持久化，但是TRY_PARSE使我的函数是非确定性的。我能做点什么吗?有替代品吗?

CREATE FUNCTION [dbo].[F] 
(
    @input nvarchar(100)
)
RETURNS int
WITH SCHEMABINDING
AS
BEGIN
    return TRY_PARSE(@input as INT)
END

SELECT OBJECTPROPERTY(OBJECT_ID('[dbo].[F]'), 'IsDeterministic')

Answer 1

用TRY_CONVERT代替:

CREATE FUNCTION [dbo].[F] 
(
    @input nvarchar(100)
)
RETURNS int
WITH SCHEMABINDING
AS
BEGIN
    return TRY_CONVERT(INT,@input)
END

SELECT OBJECTPROPERTY(OBJECT_ID('[dbo].[F]'), 'IsDeterministic')