Browse by Tags

• Bugs
• Documentation
• Tips & Tricks

• When a Function is indeed a Constant

  In my last blog post:   http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx I mentioned that I ran across a situation in which GETDATE() used in a SELECT statement occasionally returned more than 1 value for Read More... Posted Saturday, March 01, 2008 12:19 PM by Andrew Kelly | 5 Comments Filed under: Documentation, Tips & Tricks, TSQL

• When GETDATE() is not a constant

  A short while ago I was collecting wait stat information at a client and ran across a very peculiar situation that I would like to share. Let me start by saying that for years I have coded with the understanding that when you include a system function Read More... Posted Wednesday, February 27, 2008 11:53 AM by Andrew Kelly | 20 Comments Filed under: TSQL, Bugs