comma delimited string as a variable

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Eve SSCrazy Points: 2480 More actions · Answer 1

What are you trying to do - pass a delimited string of parameters and then process each as separate parameter or include in a search like

select smth from tbl

where col in (@mydelimitedstring)

Steve Jones - SSC Editor SSC Guru Points: 735912 More actions · Answer 2

You just pass it in as a varchar.

create procedure MyPRoc

@MyParam varchar(100)

as

select @MyParam

return

go

declare @C varchar( 100)

select @C = '1,2,3,4,5'

exec MyPRoc @C

Steve Jones