spDelete_ClassYearNotes
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PKID | int | IN | |
@CurrentUsersID | int | IN |
Definition
Copy
CREATE procedure spDelete_ClassYearNotes
(
@PKID int,
@CurrentUsersID int
)
as
declare @Guid uniqueidentifier
begin transaction
delete FROM ClassYearNotes where ID = @PKID
/*select @Guid = Guid from ClassYearNotes where ID = @PKID
exec spAuditThis @CurrentUsersID, 3, @Guid, 6*/
commit