Store Procced

Update

ALTER PROCEDURE updatesp
(
@empid1 int,
@empnm1 varchar(50),
@address1 nvarchar(50),
@city1 varchar(50),
@des1 varchar(50),
@dob1 date
)
AS
UPDATE empdet
SET empnm =@empnm1, address =@address1, city =@city1, des =@des1, dob =@dob1 where empid=@empid1