I am trying to update the current system Date & time into SQL Database, but getting below error can anyone please advice on this hot to fix this.
Below is my SQL Query.
Below is the Parameters.
Below is the Error.
I am trying to update the current system Date & time into SQL Database, but getting below error can anyone please advice on this hot to fix this.
Below is my SQL Query.
Below is the Parameters.
Below is the Error.
you have to pass the variables in values part!
like this values(+BATCHNO+ “,” +DESCRIPTION+ “,” and so on)
cheers
@nm09011985
be aware of the + signs must connect the variables with the static text of your query like:
"SELECT * FROM TABLE1 WHERE NAME="+myVariableName+" AND TEST="+myVariableTest