spDelete_ClientDonations
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE procedure spDelete_ClientDonations
(
@PKID int,
@CurrentUsersID int
)
as
declare @Guid uniqueidentifier
begin transaction
delete from clientdonations where id=@PKID
/* Update ClientDonations
set Deleted = 1
where Id = @PKID
select @Guid =Guid from ClientDonations where id = @PKID
exec spAuditThis @CurrentUsersID, 3, @Guid, 10
*/
commit transaction