USP_MKTCONSTITUENTFILEIMPORT_ADDCOLUMN

Adds a new column to the constituent file import data table.

Parameters

Parameter	Parameter Type	Mode
@SEGMENTATIONID	uniqueidentifier	IN
@COLUMNNAME	nvarchar(128)	IN
@DATATYPE	nvarchar(128)	IN

Definition

Copy



create procedure dbo.[USP_MKTCONSTITUENTFILEIMPORT_ADDCOLUMN]
(
  @SEGMENTATIONID uniqueidentifier,
  @COLUMNNAME nvarchar(128),
  @DATATYPE nvarchar(128)
)
with execute as owner
as
  set nocount on;

  declare @SQL nvarchar(500);
  declare @ADDORALTER nvarchar(12);
  declare @DATATABLE nvarchar(256);

  begin try

    set @DATATABLE = dbo.[UFN_MKTCONSTITUENTFILEIMPORT_BUILDTABLENAME](@SEGMENTATIONID);

    if dbo.[UFN_MKTCOMMON_COLUMNEXISTS](@DATATABLE, @COLUMNNAME) = 1
      set @ADDORALTER = 'alter column';
    else
      set @ADDORALTER = 'add';

    set @SQL = 'alter table [dbo].[' + @DATATABLE + '] ' + @ADDORALTER + ' [' + @COLUMNNAME + '] ' + @DATATYPE + ' null';
    exec (@SQL);
  end try

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

  return 0;