Delete Transact-SQL Stored Procedure

This Transact-SQL stored procedure deletes a single record from the table.

Parameter Name	Type	Description
p_id	INTEGER	Primary key value for the record to be deleted.