CREATE PROCEDURE sp_Emp_Save
(
@Eno INT,
@Ename VARCHAR(100),
@JOb VARCHAR(100),
@Gender CHAR(1),
@Sno INT,
@Sname VARCHAR(100)
)
AS
BEGIN
IF NOT EXISTS (SELECT Ename,Job FROM EMP WHERE Eno = @Eno)
BEGIN
INSERT INTO EMP (Eno,Ename,Job,Gender) VALUES (@Eno,@Ename,@Job,@Gender)
INSERT INTO Class (Sno,Sname) VALUES (@Sno,@Sname)
END
ELSE
BEGIN
UPDATE EMP SET Ename = @Ename, Job = @Job, Gender = @Gender WHERE Eno = @Eno
UPDATE CLASS SET Sname = @Sname WHERE Sno = @sno
END
END