CREATE TYPE [dbo].[CampaignIdList] AS TABLE(
 [BLMJ] NVARCHAR(50) NOT NULL
 )
GO
CREATE PROCEDURE [dbo].[casp_GetExist] 
	@BLMJ_LIST CampaignIdList READONLY
AS
BEGIN
	SET NOCOUNT ON;
 Select * from @BLMJ_LIST

END
GO

declare @p3 dbo.CampaignIdList
insert into @p3 values(N'1247')
insert into @p3 values(N'1261')
insert into @p3 values(N'1277')
insert into @p3 values(N'1279')
insert into @p3 values(N'1289')
select * from  @p3 -->> isee that there is data in @p3
 execute sp_executesql N'exec casp_GetExist',N'@BLMJ_LIST CampaignIdList READONLY',@p3

execute sp_executesql N'exec casp_GetExist @BLMJ_LIST',N'@BLMJ_LIST CampaignIdList READONLY',@p3;

exec casp_GetExist @BLMJ_LIST=@p3;

SqlCommand cmd = new SqlCommand("casp_GetExist", cnt);
            SqlParameter parameter = new SqlParameter();
            cmd.CommandType = CommandType.StoredProcedure;
            //The parameter for the SP must be of SqlDbType.Structured 
            parameter.ParameterName = "@BLMJ_LIST";
            parameter.TypeName = "CampaignIdList"; 
            parameter.SqlDbType = System.Data.SqlDbType.Structured;
            parameter.Value = dataTable;
            cmd.Parameters.Add(parameter);
            SqlDataReader sqlDR = cmd.ExecuteReader();