"DeleteAnnouncement" Stored Procedure

This stored procedure deletes a single announcement item from the database. The input parameter is ItemID, the primary key for the record.

    
   CREATE PROCEDURE Portal_DeleteAnnouncement
   (
       @ItemID int
   )
   AS
   
   DELETE FROM Portal_Announcements
   
   WHERE
       ItemID = @ItemID
        

Announcements:  Each record in the Announcements table is a single item, as displayed by the Announcements Portal Module. Since all Announcement modules store their record in this table, each item contains a ModuleID to permit related items to be retrieved in a single query.

The primary key in this table is the ItemID identity field. Note that announcement descriptions are limited to 2000 characters.