Hugo Kornelis (7/23/2013)

...

In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an INTO keyword....

Very very very GOOD question.

😀

mickyT (7/17/2013)

---

Interesting question thanks:-)

I think it also provides a good argument for the use of statement terminators or formatting scripts in a clear manor (with comments:-D).

Batch...

kapil_kk (7/16/2013)

---

Hi,

as per the explanation- The stmt "return (select 5)" gives error because in a batch RETURN with integer_expression is not admitted (note: PARENTHESIS cast the SELECT to an integer_expression...

L' Eomot Inversé (7/9/2013)

---

Nice straightforward question. Good to see a question about another new feature in SQL 2012.

However, introducing a weird ODBC function into T-SQL seems to me a...

Hugo Kornelis (7/9/2013)

---

Yup. If you wanted to get 'HellotestString', you'd use...

Some formatting with CONCAT:

SELECT

concat

(

'Name: ',t.name

...

select concat(null + 'Hello','testString') as a

, null+'testString' as b

It simply returns 'testString', NULL

😀

Wonderfull!

You gave me a good Idea.

😀

Iggy-SQL (7/2/2013)

---

To me, the explanation isn't quite right. I believe the right explanation should be something along this line:

Statement 1 : The SQL Database Engine converted the Val value to...

Hugo Kornelis (6/19/2013)

---

L' Eomot Inversé (6/19/2013)

---

After all, case-sensitive collations are an absolute pain for almost all purposes, so it might be a good idea to get people whose servers are...

matthew.flower (6/19/2013)

---

It is all very well saying "re-run it with this additional line" when the returned error from the code in the question is exactly the wording of one of...

Richard Warr (6/19/2013)

---

I ran the code and got:

Msg 242, Level 16, State 3, Line 7

The conversion of a varchar data type to a datetime data type resulted in an out-of-range...

If the statement begins with

set dateformat ymd,

the qotd would be perfect.

Hugo Kornelis (6/8/2013)

---

nenad-zivkovic (6/7/2013)

---

Should be "Avoid using float or real columns." Period....