USP_DATAFORMTEMPLATE_EDIT_MKTCONTACT

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONTACT_LASTNAME	nvarchar(100)	IN	Last name
@CONTACT_FIRSTNAME	nvarchar(50)	IN	First name
@CONTACT_MIDDLENAME	nvarchar(50)	IN	Middle name
@CONTACT_TITLECODEID	uniqueidentifier	IN	Title
@CONTACT_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@CONTACT_NICKNAME	nvarchar(50)	IN	Nickname
@CONTACT_PICTURE	varbinary	IN	Picture
@CONTACT_PICTURETHUMBNAIL	varbinary	IN	Picture thumbnail
@CONTACT_PICTURECHANGED	bit	IN	Picture changed?

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_MKTCONTACT
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONTACT_LASTNAME nvarchar(100),
    @CONTACT_FIRSTNAME nvarchar(50),
    @CONTACT_MIDDLENAME nvarchar(50),
    @CONTACT_TITLECODEID uniqueidentifier,
    @CONTACT_SUFFIXCODEID uniqueidentifier,
    @CONTACT_NICKNAME nvarchar(50),
    @CONTACT_PICTURE varbinary(max),
    @CONTACT_PICTURETHUMBNAIL varbinary(max),
    @CONTACT_PICTURECHANGED bit
)

as
    set nocount on;

    declare @CONTACT_TITLE2CODEID uniqueidentifier;
    declare @CONTACT_SUFFIX2CODEID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MKTCONTACT
        @ID = @ID,
        @CONTACT_TITLE2CODEID = @CONTACT_TITLE2CODEID output,
        @CONTACT_SUFFIX2CODEID = @CONTACT_SUFFIX2CODEID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MKTCONTACT_2
        @ID,
        @CHANGEAGENTID,
        @CONTACT_LASTNAME,
        @CONTACT_FIRSTNAME,
        @CONTACT_MIDDLENAME,
        @CONTACT_TITLECODEID,
        @CONTACT_SUFFIXCODEID,
        @CONTACT_NICKNAME,
        @CONTACT_PICTURE,
        @CONTACT_PICTURETHUMBNAIL,
        @CONTACT_PICTURECHANGED,
        @CONTACT_TITLE2CODEID,
        @CONTACT_SUFFIX2CODEID

    return 0;