SQL NOW() wont work in Stored Procedures

Hey everyone im back after long time.. :)

This time i'm gonna give you a little solution to a problem i faced few weeks ago.

Have you ever wondered why 'NOW()' wont work in MSSQL Stored Procedure?
Yes, i wondered too.

So the replacment to 'NOW()' is 'GETDATE()' :)
So just use 'GETDATE()' it will give you the same result as 'NOW()'

Hope this little solution helps you
And i'm back now to give you all more solutions :)

No comments:

Post a Comment