spAddUpdate_FundRaiserPages
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @FundRaiserID | int | IN | |
| @DisplayName | nvarchar(100) | IN | |
| @SitePageID | int | IN | |
| @PageType | int | IN | |
| @IsDefault | bit | IN |
Definition
Copy
CREATE PROCEDURE dbo.spAddUpdate_FundRaiserPages
(
@PKID int output,
@FundRaiserID int,
@DisplayName nvarchar(100),
@SitePageID int,
@PageType int,
@IsDefault bit
)
AS
begin transaction
if (@PKID<=0)
begin
INSERT INTO FundRaiserPages
(
FundRaiserID,
DisplayName,
SitePageID,
PageType,
IsDefault
)VALUES(
@FundRaiserID,
@DisplayName,
@SitePageID,
@PageType,
@IsDefault
)
SELECT
@PKID = @@Identity
end else begin
UPDATE FundRaiserPages SET
FundRaiserID =@FundRaiserID,
DisplayName =@DisplayName,
SitePageID =@SitePageID,
PageType =@PageType,
IsDefault =@IsDefault
WHERE ID=@PKID
end
commit transaction