spAddUpdate_MessageFolder
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @NetAccountID | int | IN | |
| @Name | nvarchar(50) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_MessageFolder]
(
@PKID int output,
@NetAccountID int,
@Name nvarchar(50)
)
AS
BEGIN
IF (@PKID<=0)
BEGIN
INSERT INTO [MessageFolder]
(
NetAccountID ,
Name
)
VALUES
(
@NetAccountID ,
@Name
)
SELECT @PKID = @@Identity
END
ELSE
UPDATE [MessageFolder] SET
NetAccountID = @NetAccountID ,
Name = @Name
WHERE [ID]=@PKID
END