sql - How to pass a list of Ints to a stored procedure -

sql - How to pass a list of Ints to a stored procedure -

i created stored proc in sql server 2012 using following:

create type dbo.enctypefilter table ( enctypefilterid int ); go set ansi_nulls on go set quoted_identifier on go create procedure getexplorerdata @enctypefilterlist dbo.enctypefilter readonly begin ... end

i error "operand type clash: varchar incompatible enctypefilter" when phone call procedure next command:

exec getexplorerdata @enctypefilterlist='(1,2,3,4)'

so, how pass list of ints param procedure?

you can't auto-cast varchar table contents. utilize this:

declare @enctypefilterlist dbo.enctypefilter insert @enctypefilterlist values (1), (2), (3), (4); exec getexplorerdata @enctypefilterlist

sql stored-procedures