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 = @@Identity<--- A quoi correspond @@Identity dans cette procédure stockée
Merçi d'avance
Partager