spDelete_EventItems
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spDelete_EventItems
(
@PKID int,
@CurrentUsersID int
)
AS
declare @Guid uniqueidentifier
begin transaction
/* Update Clients set Deleted = 1 where ID = @PKID
select @Guid = Guid from Clients where ID = @PKID
exec spAuditThis @CurrentUsersID, 3, @Guid, 16 */
DELETE FROM EventItems WHERE ID=@PKID
commit