Combining multiple statements

You can enter multiple statements into Interactive SQL; use a semicolon (;) to separate each statement.

1. Enter these commands into the SQL Statements pane.

   UPDATE Employees
   SET DepartmentID = 400,
       ManagerID = 1576
   WHERE EmployeeID = 467;
   
   UPDATE Employees
   SET DepartmentID = 400,
       ManagerID = 1576
   WHERE EmployeeID = 195;
   
   SELECT *
   FROM employees
   WHERE EmployeeID IN ( 195, 467 );
   

2. On the toolbar, click Execute SQL Statement. All three statements are executed. After execution, the commands remain in the SQL Statements pane. To clear this pane, press the Esc key.