A question that enables most people to get the correct answer after some careful thought is by no means "too simple". Especially as over 1/3 of respondants have got it...

Thanks, nice to have one that relies on logic as well as "book learning" 😉

The prospect of a long-haul...

GSquared (4/27/2011)

---

Richard Warr (4/27/2011)

---

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then...

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in 1NF?

Is this the filtered index introduced in SQL Server 2008? See if this rings any bells:

http://blog.sqlauthority.com/2008/09/01/sql-server-2008-introduction-to-filtered-index-improve-performance-with-filtered-index/

I agree with Alan. I've worked from home before and always found it hard to switch off. Now I have a 75-minute trip each way but when I'm home I'm...

Hi Sharon,

Another way is:

select SUBSTRING(@s,CHARINDEX('sum=',@s,1)+4,CHARINDEX('sum',@s,CHARINDEX('sum=',@s,1)+1) - CHARINDEX('sum=',@s,1)-4)

where @s-2 is your original string.

Although the OP is over seven years old it's clear that there are still lessons to be learned here for many of us. Is it really a requirement to have...

There should have been a fifth choice.

"Ring the DBA and tell him you wand Service Broker enabled"

cengland0 (4/20/2011)

---

I was wondering how you could have an "All of the above" option with a "Choose Two" directive. Let's say, for instance, that all of them were correct....

Can you say

SELECT OrderNumber COLLATE SQL_Latin1_General_CP1_CI_AS

FROM [SERVERB].[DatabaseB].dbo.[TableB][/quote]

in the second bit?

Thanks for all the useful tips and advice. I'll have a look at Mike's article over the weekend plus some of the other resources mentioned.

It's a sunny spring day...

SELECT RIGHT('000'+CAST(CAST(MyField AS INT) AS VARCHAR(4)),4) should do the trick

Good question. Being in London (where we speak a 'foreign' version of English) helped to get it right.:-)