Good question!

This is the main reason I avoid ISNULL, if possible.

Another aspect is the nullability of the result. ISNULL will infer that from the nullability of the second argument, whereas...

Well, then. Eventually, your answer might be re-flagged.

And when did you answer the question? I have the same on, but I know I answered before Steve corrected the answers.

Current time is: Not enough coffee?

Somewhere in the back of my head I hear Steve singing:

"Oops, I did it again"

There must be a constraint missing on the table with correct answers...

Having read the actual feedback request, the question makes more sense. I'm not sure why the current implementation precludes application provided start times. Obviously, there would have to be a...

If you need to log time in different time zones then why not simply store the timestamps in UTC format? Then you can build the display logic to convert...

• This reply was modified 7 years, 1 months ago by Rune Bivrin.

And to be picky, the error really doesn't have anything to do with column sets. It simply addresses the fact that there are more items in the VALUES list than...

Amazing!

I didn't realize it was October 12 already 🙂

Interestingly enough, the referenced article doesn't really say anything about spaces. I'd even go so far as to say the article is just about as useless as the function itself...

And why would you not use the Script() method, given that it exists?

And this is why you should ALWAYS use two-part column names, preferably with well chosen table aliases.