User Variables

4 important questions on User Variables

What is the assignment operator in a SELECT statement with user variables?

:=

What is the difference between user variables and local variables?

Local variables are declared with DECLARE and are not referred to with a leading @

How long do user variables exist?

For the duration of the connection
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

Are user variables shared among connections?

No

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo