Character Field Declaration

Question

Post reply

Character Field Declaration

Mark Grout

SSChasing Mays

Points: 602
More actions
February 10, 2014 at 10:32 pm

#304303

Comments posted to this topic are about the item Character Field Declaration

Viewing 15 posts - 1 through 15 (of 43 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Nice question - thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

ashwani24 Ten Centuries Points: 1071 More actions · Answer 2

Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

Easy one.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Nice one question.

I was sincerely in doubt, but since it wasn't raining I chose the correct answer.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

ashwani24 (2/10/2014)
Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

It is an unwritten rule that unless specified otherwise, the latest general available version is assumed.

At the moment of this question, that is SQL Server 2012.

The question is also valid for the two previous versions, SQL Server 2008 and 2008R2, so claiming that the question is incorrect because of an almost 10-year old version seems like nitpicking to me.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Stuart Davies SSCoach Points: 19505 More actions · Answer 6

Nice question

Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

paul s-306273 SSChampion Points: 10730 More actions · Answer 7

ashwani24 (2/10/2014)
Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.

+1

Also, if in Somerset UK, the 'Raining' option is also true.

Louisa Whitton SSCrazy Points: 2577 More actions · Answer 8

Stuart Davies (2/11/2014)
Nice question
Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England

Here in the north of England "it's already raining" would always be the correct answer 😀

I hope you're not affected by the flooding, Stuart. For once it looks worse down there than up here.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

paul s-306273 (2/11/2014)
ashwani24 (2/10/2014)
Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.
+1
Also, if in Somerset UK, the 'Raining' option is also true.

Sun is shining in Belgium 😎

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Louisa Whitton SSCrazy Points: 2577 More actions · Answer 10

Koen Verbeeck (2/11/2014)
ashwani24 (2/10/2014)
Answer is both i.e. success as well as fail, Fail in 2005 or lower version and success in 2008 or above as you have not specified any version to execute.
It is an unwritten rule that unless specified otherwise, the latest general available version is assumed.
At the moment of this question, that is SQL Server 2012.
The question is also valid for the two previous versions, SQL Server 2008 and 2008R2, so claiming that the question is incorrect because of an almost 10-year old version seems like nitpicking to me.

I wonder what proportion of you are still (like us) using the "almost 10-year old version"?

(We are doing preliminary work towards upgrading to 2012).

Neil Burton SSC-Insane Points: 22993 More actions · Answer 11

martin.whitton (2/11/2014)
Stuart Davies (2/11/2014)
Nice question
Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England
Here in the north of England "it's already raining" would always be the correct answer 😀
I hope you're not affected by the flooding, Stuart. For once it looks worse down there than up here.

+1

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

J.Faehrmann SSC Eights! Points: 957 More actions · Answer 12

I just had to choose option 3 😀

Seriously, it would fail in my environment (SQL Server 2005) but work with newer versions as stated above.

Richard Warr SSCertifiable Points: 6966 More actions · Answer 13

Well, I ran the code and it started raining (in London).

I feel I should throw my toys out of the pram and demand "my" point back as is the norm in such situations 😉

Fortunately I'd worked it out anyway.

paul s-306273 SSChampion Points: 10730 More actions · Answer 14

BWFC (2/11/2014)
martin.whitton (2/11/2014)
Stuart Davies (2/11/2014)
Nice question
Glad I answered it after my first coffee - knew it wasn't "it starts raining" even though I live in the west of England
Here in the north of England "it's already raining" would always be the correct answer 😀
I hope you're not affected by the flooding, Stuart. For once it looks worse down there than up here.
+1

Surely BWFC doesn't mean Bolton Wanderers...

Greetings from rainy Manchester!