boobalanmca07 (12/4/2012)

---

i have using two query in stored procedure, i want to use insert query in some time only
alter proc proc_emp1
@i int,
@pempid int,@pempname varchar(30),@pm1 int,@sm1 int
as
print @i
if @i<=1

begin
--if @i='I'
insert into emp1(empid,empname,m1)values(@pempid,@pempname,@pm1)
end

if @i>=1

begin
update emp1
set m1=@sm1
where empname='laila'
end

execute procedure:
exec proc_emp1 @i=0,@pm1=44,@pempid=3,@pempname='khan'
error:
Msg 201, Level 16, State 4, Procedure proc_emp1, Line 0
Procedure or Function 'proc_emp1' expects parameter '@sm1', which was not supplied.