Translate

Monday, 2 February 2015

Procedure Error Handleing

create proc MyProcedure
(
@Emp_Id int,
@Name nvarchar(50),
@Action varchar(3),
@message nvarchar(100) output
)
as
begin
 if(@Action='U')
 begin
  update tblEMP set E_name=@Name where Emp_Id=@Emp_Id  
 end    
 if(@@ERROR=0)
  set @message='Save successfully.'
 else
  set @message='Error in deletion.'
end  

No comments:

Post a Comment