Hi,
Virtual Dataport has a procedural language to create stored procedures that would invoke VQL statements and allows us to use elements such as conditions and loops.
If I need to **declare a variable and assign value** to that variable using VQL stored procedures, then I would use the below commands .
```
Variable_name <datatype>;
Variable_name:= <value_of_variable>;
```
The syntax for creating a simple VQL procedure is given below:
```
CREATE OR REPLACE VQL PROCEDURE <name_of_the_procedure>
(<variable_name> <Type_of_variable> <data_type>)
AS (
local_variable <data_type>;
)
BEGIN
<Command1>
<Command2>
END
```
For further information about developing VQL procedures, please refer to the [Developing VQL Stored Procedures](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_stored_procedures/developing_vql_stored_procedures) section under the Virtual DataPort Developer Guide .
Hope this helps!
