The only option that is definitely wrong is number 1.

As has been said, there's not really any such thing as a Unique Key in T-SQL.

'List all the differences...' - there...

Thanks for the explanation, I should have gone through it step by step just like...

I really like the question - you had to carefully go through each example to get the right answers - shame about the 'choose 2' cock-up but it did make...

I like this question, as you can work it out with a bit of thought but it doesn't take all day. And I learnt something new. Thank you!

🙂

Hugo Kornelis (12/12/2012)

---

As happens more often with a Question of the Day: Good idea, but badly executed.

If you exactly follow the instructions, executing the 'alter proc' script after making the...

More STUFFing - it must be nearly Christmas. Thanks for the question.

Toreador (12/6/2012)

---

That's exactly the conversation I had with myself. Was this a trick question or not? In the end I went...

So to correctly test for just those characters should you use:

@x IN ('a','e','i','o','u') ?

Good question, an undocumented 'feature' that could lead to unexpected results.

Toreador (11/30/2012)

---

Luckily I didn't not fail to get this wrong, but it wasn't easy due to all the double negatives.

The correct answer to most of them is of course 'it...

Example:

DECLARE @meateater char(1)

-- Change if you like to eat dead things

SET @meateater = 'N'

IF @meateater = 'N'

SELECT STUFF('Free_delicious_turkeys',6,9,'all_the_poor')

ELSE

SELECT STUFF('Free_delicious_turkeys',1,4,'Eat_all_the')

Happy Thanksgiving USA!

Go Pats!

Now back to work...

@hugo - Thank you for your comprehensive contributions - most educational! 🙂