• ALTER PROCEDURE using INSERT

• Below is a selection from the wikitechytable table used in the examples:

• ALTER PROCEDURE using Insert

ALTER PROCEDURE GetDataSP
(
@id INTEGER
@name VARCHAR(10),
@course VARCHAR(10),
@fees INTEGER,
@StatementType NVARCHAR(20) = ''
)
AS
BEGIN
  BEGIN
      IF @StatementType = 'Insert'
          INSERT INTO wikitechytable (id, name, coure, fees)
          VALUES (@id, @name, @coure, @fees)
  END
END

EXEC GetDataSP @id=110, @name='Ajay', @course = 'SQL' , @fees=200, @StatementType = 'Insert' ;