It's broken so no, it's not great.

I'd no more ask this person to administer my database than I'd ask Donald Trump to run my country.

Try rendering it with check boxes rather than radio buttons. UI 101.

Vide supra.

David Day (3/18/2016)

---

Then (with all due respect) the questions either need to indicate the version, or have version-specific options. Given the mess the latter would become, the former would...

David Day (3/18/2016)

---

Except, when I cut-and-paste from the question:

SELECT

TRY_CONVERT(VARCHAR(10), 'Mar 34, 2016 4:56 PM')

I get an error:

Msg 195, Level 15, State 10, Line 3

'VARCHAR' is not...

Andrew Watson-478275 (3/18/2016)

---

edwardwill (3/18/2016)

---

I pasted the example into a query window and pressed F5

SELECT

...

I pasted the example into a query window and pressed F5

SELECT

TRY_CONVERT(VARCHAR(10), 'Mar...

I get an error:

Msg 195, Level 15, State 10, Line 1

'VARCHAR' is not a recognized built-in function name.

Msg 195, Level 15, State 10, Line 1

'VARCHAR' is not a recognized built-in function name.

sipas (2/9/2016)

---

I like the ones where you have to try and figure out what's wrong with the question, then go for the option you think the questioner intended - thanks...

Yet another question where "None of the above" is the correct answer.

See attachment.

Edward

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be a...

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be a bit of a...