3
Answers

Pass multiple values in single parameter -Procedure

Sai Reddy

Sai Reddy
6y
596
1
 Hi, Please help me to achieve this.
The ID values are as follows. 
100
101
102
103
104
105
106
 
CREATE PROCedure Survey
@id INT
AS
BEGIN
SELECT * FROM SOUTH WHERE Surveyid=@id
end
 
How to call procedure with two values like as
 
EXECUTE Survey '100,101' 
Answers (3)
Next Recommended Forum