What is a named variable and why use it?

[kenn_rosie]

What is a named variable and why use it?
The variable @namedVariable is a "named variable."
The "@" prefix is required for SQL Server named parameters.

[exterminator]

What is a named variable and why use it?
The variable @namedVariable is a "named variable."
The "@" prefix is required for SQL Server named parameters.For any other reason why we use variables in any other programming language. To store values, manipulate them, use them. Stored procedures and dynamic queries use them a lot. When writing PL/SQL code, you can't do without them. Hope this helps. Regards.