How to Create Procedure in SQL

Alter PROCEDURE Sp_StudentCRUD

(

    @Operation nvarchar(10),

    @id int,

    @name varchar(250)

)

AS

BEGIN

    DECLARE @sql nvarchar(max) = N'';

    IF @Operation = 'Create'

    BEGIN

        SET @sql = N'INSERT INTO tblStudent (name) VALUES (@name);';

    END

    ELSE IF @Operation = 'Get'

    BEGIN

        SET @sql = N'SELECT * FROM tblStudent WHERE id = @id;';

    END

    ELSE IF @Operation = 'Update'

    BEGIN

        SET @sql = N'UPDATE tblStudent SET name = @name WHERE id = @id;';

    END

    ELSE IF @Operation = 'Delete'

    BEGIN

        SET @sql = N'DELETE FROM tblStudent WHERE id = @id;';

    END

    EXEC sp_executesql @sql, N'@id int, @name varchar(250)', @id, @name;

END

GO

 --EXEC [dbo].Sp_StudentCRUD @Operation = 'Get',@id = 1, @Name = null;