In one of the tSQLt tests I am writing I call a method with parameters to fill the expected table like so:
@CommencementDt = DATEADD(MONTH, 1, GETDATE)
However I am getting an error over the MONTH part of the second line reading:
'Incorrect syntax near MONTH, expecting ( or SELECT'
I'm new to using parameterised methods and was wandering why this wasn't working, and how I might solve it? Thanks