• ALTER PROCEDURE using DELETE

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

• ALTER PROCEDURE using Delete

ALTER PROCEDURE GetDataSP
(
@id INTEGER
@StatementType NVARCHAR(20) = ''
)
AS
BEGIN
  BEGIN
      IF @StatementType = 'Delete'
          DELETE wikitechytable FROM
          WHERE id = @id
  END
END

EXEC GetDataSP @id=101, @StatementType = 'Delete' ;