USP_MKTSEGMENTLISTDATA_ADDCOLUMN

Adds a new column to the list segment import data table.

Parameters

Parameter	Parameter Type	Mode	Description
@COLUMNNAME	nvarchar(128)	IN
@DATATYPE	nvarchar(128)	IN

Definition

Copy



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

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

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

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

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

  return 0;