If someone says the different results

2009-11-17 13:27:21.190 Tuesday

2009-11-17 13:27:21.190 Tuesday

2009-11-17 12:27:21.203 Tuesday

2009-11-17 12:27:21.203 Tuesday

are the same, as the first two times are in local time and the later...

I think that the superiority of C# is only in psychics. There are no great differnces in programming languages. All differences are in the target and all are caused by...

Just a little mistake, empty string and null.

But to tell the truth, I was confused, because I know the first expression returns empty string and not a null...

Phil Factor (8/5/2008)

---

Surely this is the simplest solution? (be warned of a nasty catch when creating these 'quirky updates'. the order of execution of the update is -variable assignments first...

Andrew Watson-478275 (10/26/2009)

---

I'm glad you admitted this too. I always feel a bit guilty :blush: when...

First time I consulted BOL before answering. Who remembers all those datetime styles?

Conversions of varchar to int was mentioned. But there are other funny combinations. Conversions of n(var)char to (var)char, very nice too.

I missed variant "All of above". Why not to eat a turkey and chocolate eggs in costume under a decorated tree, watching a firework...

:hehe:

We have our holiday on monday.

My answer is Nchar(1).

I suspect author of the question of speaking (and thinking) in English. We, who use accented letters, we prefer Unicode