Answer the question
In order to leave comments, you need to log in
Is it possible to pass a dataset as a parameter to a stored procedure?
Now, to work with the database, queries of the form are used:
INSERT INTO t VALUSE (data1),(data2),...,(data_n) ON DUPLICATE KEY UPDATE param1=VALUES(param1)...
Answer the question
In order to leave comments, you need to log in
It is possible to pass it as a string ('a,b,c') and parse it in the procedure itself in the loop.
But what exactly is the table for? Why not just give her name? Or even so - set this name in advance, and then use the parameter and in it - 0 - one branch of the procedure, 1 - the second branch of the procedure with the name of this table.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question