Untitled

SQL Server: How to declare function as variable inside computed column
ALTER TABLE Ticket ADD MinutiAllaScadenza AS ( " +
CASE
WHEN StatoTicketID > 3 AND dbo.DiffMinuti(DataArrivo, DataObiettivo) <0 THEN 10000000
ELSE dbo.DiffMinuti(DataArrivo, DataObiettivo)
END)

ALTER TABLE Ticket ADD DiffMinuti INT NULL
GO
CREATE TRIGGER trg_Ticket_DiffMinuti ON Ticket
AFTER INSERT, UPDATE
AS
BEGIN

    SET NOCOUNT ON;

    IF UPDATE(DataArrivo) OR UPDATE(DataObiettivo)
    BEGIN

        UPDATE
            b
        SET
            DiffMinuti = dbo.DiffMinuti(DataArrivo, DataObiettivo)
        FROM
            INSERTED a INNER JOIN
            Ticket b ON a.TicketID = b.TicketID;

    END;

END;
GO
ALTER TABLE Ticket ADD MinutiAllaScadenza AS CASE WHEN StatoTicketID > 3 AND DiffMinuti <0 THEN 10000000  ELSE DiffMinuti END
GO