Hi everyone,
I need to pass a list of INT into a parameter of a stored procedure which should look like this:
UPDATE table01
SET updatedDate = now()
WHERE ID in (list of ids that I will pass in);
However the parameter type only accept INT, not list of INT, so not sure how can I achieve that.
Any suggestion will be much appreciated :)
Discussion posts and replies are publicly visible
Why do you need a stored procedure for this simple task?