Lempster (2/17/2009)

---

I would write it as '2009-01-31' and all my returned values are for that date. I'm using the Collation Latin1_General_CI_AS, my Location is set to United Kingdom and...

Hi Håkan,

Regional settings may affect the results, but not the...

Sam Iam (2/17/2009)

---

I didn't know that SQL Server rounded datetime...this is confusing behavior because I wouldn't have expected to see the '20090201' date in the result set. Try explaining...

Glen Parker (2/17/2009)

---

Given that SQL is logic based, its a shame that the result was so ambiguous...

Like most, I got it wrong too however given the explanation, surely the data...

I both liked and disliked this question.

The reason I like it, is that it points out a very common misconception when querying for intervals - I have lost track of...

Hi David,

Interesting question. And no, the answer...

Hi Lynnn,

I would usually agree. Not in this case, though....

I don't think the given "correct" answer is in fact "the best way", as was asked. I even doubt if it takes the least effort, as the answer key says.

If...

Shaun McGuile (2/2/2009)

---

Hugo: so what you are saying is that REPLICATE uses varchar sizing i.e. 8000 and not the destination size unless you explicitly instruction the function to use something...

Hi Shaun,

No, it's not. It just adheres to the standard operating procedure of datatype in = datatype out.

CREATE TABLE #t

...

karthik.nallajalla (2/1/2009)

---

REPLICATE( N'A', 4000000));

what is the meaning of N in N'A'? is it the maximum length.

I executed the below statements,

INSERT #t VALUES (1, REPLICATE( N'A', 4000000));

INSERT #t VALUES...

Hi Chris,

I guess the short answer would be "because only the other three are verbatim quotes from...

Hi Tom,

Thanks for your elaborate post. You raise some very interesting points, and I'll address them one at a time.

For SQL 2000 (and the question explicitly includes "before SQL 2005")...

Hi Steve,

Impersonation is a generic term for using the security settings of a user that you are not authenticated as. This term is used *both* for

(a) database users impersonating other...

EdVassie (12/19/2008)

---

Oh dear, another question where the Microsoft documentation triumphs over reality.

I have added some community content to http://msdn.microsoft.com/en-us/library/ms175049.aspx. If anyone wishes to add to it please...