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
(
@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