kumar yoga

kumar yoga

  • NA
  • 158
  • 73.4k

sqlserver stroed proc

Jun 1 2016 1:29 AM
how to create stored porcedure using  in clause sqlserver 
 
mycode
 
create proc  getemp(@ename varchar(25))
as
begin
select *  from emp where ename in(@ename)
end
go
 
exec   getemp  'aa','bb'
 
sqlserver showing error two many parametr passed   
 
 
 
 
 
 

Answers (5)