Also, is there a way to store multiple data in a single sql table with a single command?
The documentation references the cmdVal variable, but that only sends the value of the current command. So, what if I need to store several variables?
For example, table1 has two columns: variable1 and variable2. I can use an SQL query like this:
INSERT INTO table1(variable1, variable2) VALUES (@cmdVal, null)
I can only pass the data for variable1, that’s why I am forced to pass a null value to variable2. Do I need to create an aditional command to write variable2 on the table?