Forum Discussion

sdelano's avatar
sdelano
New Contributor II
3 years ago

Passing a custom sql server data type into a stored procedure

Given the below sql server procedure definition excerpt. How would we pass in an array of data into this this datatype as the input parameter of the stored procedure. when passing in a straight array...
pipeline
Abhishek_Soni37's avatar
Abhishek_Soni37
Contributor
3 years ago

Hi @sdelano

You can pass it as a delimited string, then while the SP gets executed you can use SQL function STRING_SPLIT() and use it.

I hope this helps.

Cheers!