Sai Reddy

Sai Reddy

  • NA
  • 214
  • 31.7k

Pass multiple values in single parameter -Procedure

Oct 12 2018 10:25 PM
 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)