SQL - Stored Procedures and Functions
Which of the following is a correct way to assign a value to a variable in SQL?
Which of the following is a correct way to assign a value to a variable in SQL?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Recall the syntax for assigning values to variables
In SQL, after declaring a variable, theSETstatement is used to assign a value.Step 2: Identify the correct syntax
SET @var = 10;is the correct way. Other options use invalid keywords or syntax.Final Answer:
SET @var = 10; -> Option AQuick Check:
Assign value syntax = SET @var = value [OK]
Quick Trick: Use SET to assign values after DECLARE [OK]
Common Mistakes:
- Using DECLARE to assign values directly
- Using non-SQL keywords like ASSIGN or VALUE
- Incorrect assignment operators
Master "Stored Procedures and Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes