Sorry, but I think the answers are not worded correctly (so there is no correct answer in that list), so I selected the one that seemed least incorrect. And I...

Hugo Kornelis (7/1/2013)

---

Floating point numbers are stored in "exponential notation" - that is the...

The precision of a REAL is always 7.

FLOAT(24) is a synonym for REAL. Don't understand why this is not explicitely mentioned in the MSDN article.

Probably Hugo can explain us...

Hugo Kornelis (5/27/2013)

---

True, but since there is no way to manually apply formatting in the messages pane (as far as I know), the replacement text you type would still be...

Nice start of the week.

One remark though:

This not only works when an error has been generated. Any message that is...

+1

Hi, this was a nice question, however I don't fully agree with the wording

SUBSTRING is still used, but since...

Slawomir Swietoniowski (5/12/2013)

---

This question is stated wrong, cont(...) does not have any alias for the name, so, while you will try to execute this code, you will get:

Msg 1038, Level...

It also might be because it is still early here, but what is the point exactly?

. What is it exactly why it works? The fact...

I agree...

Shouldn't TCP in the answers be TSQL?

TCP is one of the two protocols that can be used, TSQL is a payload type.

Sorry to say that I also think that the wording of the answers is poor, and that the correct answer should be b.

Danny Ocean (3/21/2013)

---

Hi,

Sorry, but i am unable to understand question completely.:ermm:

If you increase varchar length then it will give right answer. Please try below T-sql statements

SELECT CONVERT(VARCHAR,GETDATE(),20)

SELECT CONVERT(VARCHAR,GETDATE(),21)

SELECT CONVERT(VARCHAR,GETDATE(),106)

SELECT CONVERT(VARCHAR,GETDATE(),107)

SELECT...

That was until your reply. 😀

But in...

Maybe another option for a(n) (in)correct answer: "Only statement 2 and 3 will succeed and 1 row will be returned...".

But probably I am the only one still having SQL Servers...