I am sorry, but your note is not clear to me.  What problem are you trying
to solve?

In any case, functions cannot update tables, so an INSERT statement should
be part of a stored procedure if you are trying to update a table. E.g.

CREATE PROCEDURE InsertStuff
(@ThingKey INT,
@ThingName NVARCHAR(100)
)
AS
INSERT INTO MyTable VALUES (@ThingKey, @ThingName)
RETURN

RLF