Help required in stored procedures
-
Hi all, i just want to know how can we programatically increase or decrease the number of parameters of a stored procedure that is stored in a DB.Let me explain it first I am reading some distinct values from a table column and depending upon the rows returned i have to set the parameters of Stored proc accordingly.The table i am reading from can contain any no of tuples. Help!!!
-
Hi all, i just want to know how can we programatically increase or decrease the number of parameters of a stored procedure that is stored in a DB.Let me explain it first I am reading some distinct values from a table column and depending upon the rows returned i have to set the parameters of Stored proc accordingly.The table i am reading from can contain any no of tuples. Help!!!
As far as I know you'd have to alter the proc to change it's parameters and you could do this programatically but at that point you might as well just do dynamic sql. Could you use a comma seperated list of values as parameters? Do have some example code for the stored procedure and what it's supposed to do?