Home Can I pass DATEADD straight into a variable?
 In one of the tSQLt tests I am writing I call a method with parameters to fill the expected table like so: EXEC Test.Insert_Expected @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