Tuesday 25 November 2014
Stored procedure skips date
If you are using date math in a stored procedure like datepart(dw,getdate()) which returns a 2 for Tuesday make sure you set the Datefirst parameter to the first day of the week for the country you are in. set DATEFIRST 1. see here
Failure to do this could result in your date calculations not running properly, Tuesday may become 3. This is due to the fact that when run manually the calculation are run differently than when a Job is run from SQL server agent.
Subscribe to:
Post Comments (Atom)
Passwords Made Easy
Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...
-
Crystal Reports datepart is slightly different than SQL and VB Interval type Description yyyy Extr...
-
If DCOB Fault comes on your main phone this means that there is no external lines available and you will need to call you service pro... -
If you have a situation that requires an application to always be up then try Restart program after a crash downloadable from https://w-s...
No comments:
Post a Comment