Techniques for In-Clause and SQL Server

DECLARE @RC int
DECLARE @InArray varchar(max) ='1,2,3,4,5,6,7,8,9,12345,'
DECLARE @Delimiter varchar(10) = ','
DECLARE @TableName sysname = '#test'
DECLARE @ColumnName sysname = 'id'
declare @JobId uniqueidentifier = NewId()

-- TODO: Set parameter values here.
create table #test
( 
--id varchar(max)
id bigint
)

EXECUTE @RC = [InClause].[dbo].[DelimBigIntListToTable2]
--EXECUTE @RC = [InClause].[dbo].[DelimListToTable2] 
   @InArray
  ,@Delimiter
  ,@TableName
  ,@ColumnName

select * from #test
drop table #test

EXECUTE @RC = [InClause].[dbo].[DelimBigIntListToParm] @List=@InArray, @Delimiter=@Delimiter, @JobId=@JobId

select * from ParmId




DECLARE @RC int
DECLARE @Ids varchar(max) = '1,4,6,7,8,4,33,66,44,55555,65,4,3,4,5,6,76,77,6,5,45,4'

-- TODO: Set parameter values here.

--EXECUTE @RC = [InClause].[dbo].[GetUsingDelimitedParmTable]    @Ids
   
   
EXECUTE @RC = [InClause].[dbo].[GetUsingDelimitedFunctionTable] 
   @Ids
   
GO

truncate table ParmId
truncate table ParmIdWithUniqueBigInt
truncate table UniqueBigInt
truncate table SomeString
--select top 100 * from SomeString

declare @test xml
--set @test = '<L><I>1</I><I>2</I><I>3</I><I>4</I><I>5</I><I>6</I><I>7</I><I>8</I><I>99999</I><I>2</I><I>3</I><I>4</I></L>'

set @test = '<I>1</I><I>2</I><I>3</I>'

select @test.exist('/I[text()[1]  = 2] ')
select @test.query('/I[text()[1]] ')
select T.c.value('.','bigint') as Id 
					from @test.nodes('/I') T(c)


declare @test2 xml
set @test2 = '<I v="1"></I><I v="2"></I>'
select @test2.query('/I/@v')
--select T.c.value('.','bigint') from @test.nodes('/ROOT/ID') T(c)


EXECUTE  [InClause].[dbo].[GetUsingXMLXQuery]
   @test
   
   
  declare @Ids IdsTableType
  insert into @Ids (Id) values(1)
  insert into @Ids (Id) values(2)
  insert into @Ids (Id) values(3)
  insert into @Ids (Id) values(4)
  
  execute GetUsingTypeParm @Ids