I have a Scenario where I need to use an Update query to update a Date column in Database table and I am trying to find out if I can create a Variable for the Date Column and pass in Date conditions through variable.
For Example:
I want to set the Datetime as: DateTime.UtcNow.AddMinutes(1) so I want to pass this value through variable.
I tried Using Execute/ Execute non Query and passed in parameters and mentioned variable name as @variable or even ’”+VarDate+"’ but nothing worked. Either its throwing an error saying incorrect syntax near keyword where or declare the scalar variable
Below are some screenshots what I am trying to do: