USP_MICROSITE_DELETE_DONATIONDESIGNATIONS
Executes the "USP_MICROSITE_DELETE_DONATIONDESIGNATIONS" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN | Input parameter indicating the ID of the record being deleted. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the delete. |
Definition
Copy
CREATE procedure dbo.USP_MICROSITE_DELETE_DONATIONDESIGNATIONS
(
@ID int,
@CHANGEAGENTID uniqueidentifier
)
as begin
--check deletion rules, if any
-- use the system generated delete routine to allow proper recording of the deleting agent
declare @ClientDonationsID int
select @ClientDonationsID = ID from dbo.ClientDonations where ContentId=@ID
delete from dbo.donationdesignations where ClientDonationsID=@ClientDonationsID
return 0;
end