spDelete_Message
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @DeletedType | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spDelete_Message]
(
@PKID int,
@DeletedType int
)
AS
BEGIN
--Soft Delete
if @DeletedType = 0
BEGIN
UPDATE Message
SET Deleted = 1, DeletedDate = getUTCdate()
WHERE
ID = @PKID
END
--Restore from Delete
if @DeletedType = 1
BEGIN
UPDATE Message
SET Deleted = 0, DeletedDate = NULL
WHERE
ID = @PKID
END
--Hard Delete
if @DeletedType = 2
BEGIN
DELETE FROM Message
WHERE
ID = @PKID
END
END