spAddUpdate_EmailProjectAppeal

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Name	nvarchar(50)	IN
@Description	nvarchar(256)	IN
@EmailProjectID	int	IN
@CurrentStep	smallint	IN

Definition

Copy



    CREATE PROCEDURE [dbo].[spAddUpdate_EmailProjectAppeal]
            @PKID int output,
            @Name nvarchar(50),
            @Description nvarchar(256),
            @EmailProjectID int,
            @CurrentStep smallint    

            as

            IF @PKID > 0
                BEGIN
                    UPDATE [dbo].[EmailProjectAppeal]
                        SET [Name] = @Name
                        ,[Description] = @Description
                        ,[EmailProjectID] = @EmailProjectID
                        ,[CurrentStep] = @CurrentStep
                    WHERE [ID] = @PKID
                END
            ELSE
                BEGIN
                    INSERT INTO [dbo].[EmailProjectAppeal]
                       ([Name]
                       ,[Description]
                       ,[EmailProjectID]
                        ,[CurrentStep])

                    VALUES
                       (@Name
                       ,@Description
                       ,@EmailProjectID
                       ,@CurrentStep)

                    SET @PKID = @@IDENTITY
                END