insert into employees(employee_id,last_name,hire_date,job_id,email) values(dep,'a',sysdate,'1','www') select department_id as dep from departments where manager_id=200;
insert into employees(employee_id,last_name,hire_date,job_id,email) select department_id, 'a', sysdate, '1', 'www' from departments where manager_id=200;
DECLARE @dep INT SELECT @dep = department_id FROM departments WHERE manager_id=200; INSERT INTO employees(dept_id, last_name, hire_date, job_id, email) VALUES(@dep,'a',sysdate,'1','www')
CREATE PROCEDURE InsertNewEmployee @manid INT, @lname VARCHAR(50), @jobid INT, @email VARCHAR(50) AS BEGIN DECLARE @dept INT SELECT @dept = COALESCE(department_id,0) FROM departments WHERE manager_id = @manid IF @dept >0 BEGIN INSERT INTO employees(dept_id, last_name, hire_date, job_id, email) VALUES(@dept,@lname,sysdate(),@jobid,@email) ELSE PRINT 'Unknown manager!' END END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)