Pass parameter list to stored procedure

1. Method1: use split function

create proc  PassArrayParamProc
@parameter nvarchar(4000)
as
begin
select 1 where  '1' in
(select  value from dbo.Split(',',@parameter)
)
end

exec PassArrayParamProc '1,2,3'

  2.  Method2: use xml parameter

  create proc  PassArrayParamXmlProc
@parameter xml
as
begin
select 1 where '2' in
(
select T.c.value('.','nvarchar(50)')
AS result from @parameter.nodes('/e')  T(c)
)
end

  exec PassArrayParamXmlProc '<e>1</e><e>2</e>'