Procedure in SQL that accepts dynamic array of inputs

Question

Does SQL Server have the ability to accept a dynamic array of inputs and loop through the values?

For example:

I have multiple products with productId. Now, there will be times that I would need to delete some of those products. I can do this now by executing a stored procedure that accepts a productId value. My problem is I need to do this one by one.

What I would like to do is to send multiple productId's to the procedure and have the proc loop through those id's.

Is this possible?

Dimt · Accepted Answer · 2014-03-22 07:49:10Z

2

This is possible in SQL Server 2008 using Table-Valued Parameters, in SQL Server 2005 is work around it by passing a Comma-separated List of Values. You can see all available options and implementations for 2008 here and for 2005 here.

answered Mar 22, 2014 at 7:49

Dimt

2,3262 gold badges24 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Procedure in SQL that accepts dynamic array of inputs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related