[Solved] You wrote this stored procedure:CREATE PROCEDURE UpdateSalary() BEGIN UPDATE Employees SET Salary = Salary + 1000 END;When you try to run CALL UpdateSalary();, you get an error.... | SQL

SQL - Stored Procedures and Functions

You wrote this stored procedure:

CREATE PROCEDURE UpdateSalary()
BEGIN
  UPDATE Employees SET Salary = Salary + 1000
END;

When you try to run CALL UpdateSalary();, you get an error. What is the likely problem?

AProcedure name cannot have uppercase letters

BMissing semicolon after UPDATE statement

CCALL keyword is incorrect

DSalary column cannot be updated

Step-by-Step Solution

Solution:

Step 1: Check procedure syntax
Each statement inside BEGIN...END must end with a semicolon.
Step 2: Identify missing semicolon
The UPDATE statement lacks a semicolon at the end, causing syntax error.
Final Answer:
Missing semicolon after UPDATE statement -> Option B
Quick Check:
Semicolon missing = B [OK]

Quick Trick: End each SQL statement with semicolon inside procedures [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

You wrote this stored procedure: