How to put insert statement in SQL function?

Question

Here is my function which I am trying

CREATE FUNCTION [dbo].[CreateNewRow] 
( @pFirstName VARCHAR(50), @pLastName VARCHAR(50) )
RETURNS INT
AS
BEGIN

INSERT INTO [dbo].[Student] ( [FirstName], [LastName] )
VALUES ( @pFirstName, @pLastName )

RETURN SCOPE_IDENTITY()
END
GO

Please let me know alternative way if possible.

Answer 1

Try using stored procedures

CREATE PROCEDURE [dbo].[CreateNewRow] @pFirstName VARCHAR(50)
    ,@pLastName VARCHAR(50)
AS
BEGIN
    INSERT INTO [dbo].[Student] (
        [FirstName]
        ,[LastName]
        )
    VALUES (
        @pFirstName
        ,@pLastName
        )

    SELECT SCOPE_IDENTITY()
END
GO

To Call your Stored Procedure

EXEC CreateNewRow @pFirstName = 'Xxx'
    ,@pLastName = 'Yyy'