Jeff Moden (2/15/2013)
Sean Lange (2/15/2013)
You should use DATEADD because the simple math does not work with date or datetime2 datatypes.I have to ask... if you're not using the DATE or DATETIME2 datatypes, why does that matter?
Consistency? Personally, I don't use the @DataVar + NumDays to add NumDays to a datetime value. I like using the DATEADD function, it provides clarity.