spDelete_FundRaiserPages
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spDelete_FundRaiserPages]
(
@PKID int,
@CurrentUsersID int
)
AS
begin transaction
update dbo.UserPersonalPages set FundRaiserPageID=null where FundRaiserPageID=@PKID
update dbo.FundRaiserTeams set FundRaiserPageID=null where FundRaiserPageID=@PKID
delete from FundRaiserPages where ID = @PKID
commit transaction