Agreed. If the SQL is executed...

Jan Van der Eecken (11/28/2012)

---

Thanks Jan. You are absolutely correct. I should have said query processor.

Sean

davoscollective (11/28/2012)

---

L' Eomot Inversé (11/28/2012)

---

seankyleprice (11/28/2012)

---

I believe I maybe have an answer as to why the behaviour of SET QUOTED_IDENTIFIER ON is different to the other set options, namely that...

I believe I maybe have an answer as to why the behaviour of SET QUOTED_IDENTIFIER ON is different to the other set options, namely that the statement is issued at...

I'm another who missed out on the varbinary(max) part f the answerl. The link provided in the explanation (which I read first as I'm not yet up to speed with...

I second guessed that the question meant statements as opposed to queries as otherwise it made no sense at all. I also second guessed that it wouldn't be 9 as...

Given that the nullability of the column wasn't explicitly specified (a personal bugbear of mine) surely the answer depends on the setting for 'ANSI null default' on tempdb and whether...

I personally think the answer should be 'none of the above'. The accuracy of sysdatetime() depends on the computer hardware and version of Windows on which the instance of SQL...

Best Practice for 2008 onwards is surely to use TRY CATCH as suggested by Stewart. For 2005 and prior I agree that the method suggested by Carlos would be best...