USP_CODETABLESECURITY_ADD

Adds a code table security record to the database.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@RECORDTYPEID	uniqueidentifier	IN
@CODETABLECATALOGID	uniqueidentifier	IN
@TABLENAME	nvarchar(100)	IN
@COLUMNNAME	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


            create procedure dbo.USP_CODETABLESECURITY_ADD
            (
                @ID uniqueidentifier = null output,
                @RECORDTYPEID uniqueidentifier,
                @CODETABLECATALOGID uniqueidentifier,
                @TABLENAME nvarchar(100),
                @COLUMNNAME nvarchar(100),
                @CHANGEAGENTID uniqueidentifier
            )
            as
                set nocount on;

                if @ID is null
                    set @ID = newid();

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                begin try
                    if not exists(select 1 from dbo.CODETABLESECURITY where TABLENAME = @TABLENAME and COLUMNNAME = @COLUMNNAME)

                        insert into dbo.CODETABLESECURITY(
                            ID,
                            RECORDTYPEID,
                            CODETABLECATALOGID,
                            TABLENAME,
                            COLUMNNAME,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                        )
                        values(
                            @ID,
                            @RECORDTYPEID,
                            @CODETABLECATALOGID,
                            @TABLENAME,
                            @COLUMNNAME,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        )

                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch;