This stored procedure adds a new announcement to the database for a specific module in the portal. The input parameters include Title, Expiration Date and Description for the announcement, and the output parameter is the ItemId of the new database record.
Definition:CREATE PROCEDURE AddAnnouncement ( @ModuleID int, @UserName nvarchar(100), @Title nvarchar(150), @MoreLink nvarchar(150), @MobileMoreLink nvarchar(150), @ExpireDate DateTime, @Description nvarchar(2000), @ItemID int OUTPUT ) AS INSERT INTO Announcements ( ModuleID, CreatedByUser, CreatedDate, Title, MoreLink, MobileMoreLink, ExpireDate, Description ) VALUES ( @ModuleID, @UserName, GetDate(), @Title, @MoreLink, @MobileMoreLink, @ExpireDate, @Description ) SELECT @ItemID = @@IdentityDatabase Tables Used:
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.