spAddUpdate_SignOnControls

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Text	nvarchar(100)	IN
@Required	bit	IN
@Display	bit	IN
@ContentID	int	IN
@AttributeTypeID	int	IN
@FieldID	int	IN
@ParentFieldID	int	IN

Definition

Copy



CREATE          PROCEDURE [dbo].[spAddUpdate_SignOnControls]
@PKID int output,
@Text nvarchar(100), 
@Required bit = 0,
@Display bit = 0,
@ContentID int, 
@AttributeTypeID int,
@FieldID int,
@ParentFieldID int

as

IF @PKID = -1
    BEGIN
        INSERT INTO SignOnControls(
            [Text], 
            Required,
            Display,
            ContentID, 
            AttributeTypeID,
            FieldID,
            ParentFieldID
            )
        VALUES(
            @Text, 
            @Required,
            @Display,
            @ContentID, 
            @AttributeTypeID,
            @FieldID,
            @ParentFieldID
               )
    END

ELSE
    BEGIN
        UPDATE SignOnControls
            SET Required = @Required, Display = @Display
        WHERE [ID] = @PKID
    END
Select @PKID = @@Identity