spAddUpdate_RealmEmail
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @RealmID | int | IN | |
| @RealmTypeID | int | IN | |
| @EmailID | int | IN | |
| @Type | int | IN | |
| @Subject | nvarchar(255) | IN | |
| @Message | ntext | IN | |
| @Closing | nvarchar(1000) | IN |
Definition
Copy
CREATE PROCEDURE dbo.spAddUpdate_RealmEmail
(
@PKID int output,
@RealmID int,
@RealmTypeID int,
@EmailID int,
@Type int,
@Subject nvarchar (255),
@Message ntext,
@Closing nvarchar (1000)
)
AS
begin transaction
if (@PKID<=0)
begin
INSERT INTO RealmEmail
(
RealmID,
RealmTypeID,
EmailID,
Type,
Subject,
Message,
Closing
)
VALUES
(
@RealmID,
@RealmTypeID,
@EmailID,
@Type,
@Subject,
@Message,
@Closing
)
SELECT
@PKID = @@Identity
end else begin
UPDATE RealmEmail SET
RealmID = @RealmID,
RealmTypeID = @RealmTypeID,
EmailID = @EmailID,
Type = @Type,
Subject = @Subject,
Message = @Message,
Closing = @Closing
WHERE ID=@PKID
end
commit transaction