USP_PDACCOUNTTABLESAVAILABLEFORSEGMENT_UPDATEENTRY

Adds/updates a system-defined entry in the PDACCOUNTTABLESAVAILABLEFORSEGMENT table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@TABLEID	nvarchar(36)	IN
@TABLENAME	nvarchar(255)	IN
@FRIENDLYTABLENAME	nvarchar(25)	IN
@DESCRIPTIONCOLUMNNAME	nvarchar(512)	IN
@ISCODETABLE	tinyint	IN
@TSLONG	int	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEGMENTTYPECODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_PDACCOUNTTABLESAVAILABLEFORSEGMENT_UPDATEENTRY(
    @ID uniqueidentifier,
    @TABLEID nvarchar(36)='',
    @TABLENAME nvarchar(255),
    @FRIENDLYTABLENAME nvarchar(25),
    @DESCRIPTIONCOLUMNNAME nvarchar(512),
    @ISCODETABLE tinyint=0,    
    @TSLONG int=0,
    @CHANGEAGENTID uniqueidentifier = NULL,
    @SEGMENTTYPECODE tinyint = 0
)
as
begin

declare @CHANGEDATE datetime;

exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CHANGEDATE = getdate();        

if (@SEGMENTTYPECODE = 0)
    raiserror('Please set the SEGMENTTYPECODE argument, 1 - Builtin segment, 2 - Custom segment.', 13, 1);

if (select count(ID) from dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT where ID = @ID) = 0
    insert into dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT(ID, TABLEID, TABLENAME, FRIENDLYTABLENAME, DESCRIPTIONCOLUMNNAME, ISCODETABLE, SEGMENTTYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values(@ID, @TABLEID, @TABLENAME, @FRIENDLYTABLENAME, @DESCRIPTIONCOLUMNNAME, @ISCODETABLE, @SEGMENTTYPECODE, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)
else
    update dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT
        set  TABLEID = @TABLEID,
                TABLENAME = @TABLENAME, 
                FRIENDLYTABLENAME = @FRIENDLYTABLENAME,
                DESCRIPTIONCOLUMNNAME = @DESCRIPTIONCOLUMNNAME,
                ISCODETABLE = @ISCODETABLE,
                SEGMENTTYPECODE = @SEGMENTTYPECODE,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CHANGEDATE
        where ID = @ID;

return 0
end