Hi,
try this
create procedure usp_LoginTable
(
@intOption int=0 ,
@Emp_name varchar(20)='',
@id varchar(10)='',
@password varchar(10)='',
@Address varchar(20)=''
)
as
begin
IF @intOption=1
begin
insert into [Login](Emp_name,id,[password],[Address])
values (@Emp_name,@id,@password,@Address)
end
ELSE IF @intOption=2
begin
update [Login] set Emp_name=@Emp_name,id=@id,[password]=@password,[Address]=@Address
where id=@id
end
ELSE IF @intOption=3
begin
Delete from [Login] where id=@id
end
end
Best Luck
Happy Coding:)