1

Possible Duplicate:
T-SQL stored procedure that accepts multiple Id values

how to add Multiple values for a single parameter while using 'in' Operator in SQL Server 'Stored Procedure'

for example:

create procedure ProcEmployee ( @DeptID int )
as
begin
select* from employee where **DeptID in (@DeptID)**
end

from the above example, i need to pass multiple values for the parameter '@DeptID'

Community
  • 1
  • 1
Prema Josh
  • 27
  • 1
  • 3

0 Answers0