SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Rahul Kr. Ghosh / T-sql / Latest Posts

RE: T-sql

skanker — Wed, 24 Aug 2011 01:16:39 GMT

Just working my way through old questions for some training.As I am relatively new to SQL this was a good test for me. I got the answer right, however the comments posted here made me think so I played with the query to test lengths, etc. Might be easy to old hands but we all need to start somewhere...

RE: T-sql

OCTom — Tue, 21 Dec 2010 11:47:21 GMT

Always specify the size. Always.

RE: T-sql

Christian Buettner-167247 — Tue, 21 Dec 2010 02:12:47 GMT

I like the question, mostly because it focuses on one aspect only - the default size.Too many times there are complicated questions which mix the question itself with ostacles and obfuscations. I then prefer repeated questions over complicated questions.Thanks!

RE: T-sql

Dhruvesh Shah — Sun, 19 Dec 2010 21:28:22 GMT

Simple one. 15% wrong answers are there b'cos few of them just select what ever they want to without even looking at question

RE: T-sql

UMG Developer — Fri, 17 Dec 2010 14:22:43 GMT

Thanks for the question!I'm still surprised by 9% of the people getting it wrong, so I guess it doesn't hurt to go over the same thing multiple times.

RE: T-sql

rmechaber — Fri, 17 Dec 2010 11:53:55 GMT

The only reason I got this right is that there was a QoD some weeks back that had a default data length as part of the question. I got that one wrong.I was taught to never rely on defaults for things like declaring variables, so out-of-sight, out-of-mind. I'd quite forgotten they existed.Anyway, thanks for letting me know I learned something from that earlier QoD!Rich

RE: T-sql

Rahul The Dba — Fri, 17 Dec 2010 09:37:56 GMT

THANKS FOR ALL YOUR POSTS.....:-)

RE: T-sql

SQLRNNR — Fri, 17 Dec 2010 09:35:43 GMT

[quote][b]Tom.Thomson (12/17/2010)[/b][hr]Nice simple question.The wrong answer rate suggests that even something as straightforward as this has some instructional value.[/quote]I agree. Maybe it should be asked several more times.

RE: T-sql

SanDroid — Fri, 17 Dec 2010 09:30:31 GMT

[quote][b]DougieCow (12/17/2010)[/b][hr][quote][b]Toreador (12/17/2010)[/b][hr]How many times do we have to have questions about the default precision of strings before everyone gets them right?![/quote]Never, there will always be somebody new.[/quote]I agree Dougie. Also, if you have submitted a question you know that as long as it takes for one to be published there is a high chance that someone else will post something covering the same topic.As far as the answers go, I almost selected the 'HI YO' answer cause I thought it was funny.Thanks for the easy point on a friday and some giggle factor in the answers.

RE: T-sql

L' Eomot Inversé — Fri, 17 Dec 2010 07:12:57 GMT

Nice simple question.The wrong answer rate suggests that even something as straightforward as this has some instructional value.

RE: T-sql

sjimmo — Fri, 17 Dec 2010 06:45:32 GMT

Rahul The Dba Welcome to the forum. Good question. Many will complain about simplicity or the number of times that this type of question has been asked, but it is also good to refresh on even the simplest of things.

RE: T-sql

Abi Chapagai — Fri, 17 Dec 2010 05:29:28 GMT

I agree that this questions been asked many times, but it is good to have this kind of generic question because there will be new members who want to learn every little piece of SQL Server. Good question.

RE: T-sql

cengland0 — Fri, 17 Dec 2010 03:00:37 GMT

True that this question has been asked multiple times in different ways but I finally got an easy point without having to think too much.

RE: T-sql

DugyC — Fri, 17 Dec 2010 02:54:22 GMT

[quote][b]Toreador (12/17/2010)[/b][hr]How many times do we have to have questions about the default precision of strings before everyone gets them right?![/quote]Never, there will always be somebody new.Good simple question, perfect for the end of the week. Thanks.

RE: T-sql

Toreador — Fri, 17 Dec 2010 02:34:37 GMT

How many times do we have to have questions about the default precision of strings before everyone gets them right?!

RE: T-sql

grahamc — Fri, 17 Dec 2010 02:29:15 GMT

[quote][b]Carlo Romagnano (12/17/2010)[/b][hr]Old question and repeated many times.[/quote]Too many honestly...

RE: T-sql

Richard Warr — Fri, 17 Dec 2010 02:10:59 GMT

[quote][b]Carlo Romagnano (12/17/2010)[/b][hr]Old question and repeated many times.[/quote]True, but there are always new members here. And one in seven (so far) has got it wrong.

RE: T-sql

Koen Verbeeck — Fri, 17 Dec 2010 01:32:16 GMT

[quote][b]Carlo Romagnano (12/17/2010)[/b][hr]Old question and repeated many times.[/quote]Couldn't agree more. But thanks for the effort anyway.

RE: T-sql

Carlo Romagnano — Fri, 17 Dec 2010 00:58:30 GMT

Old question and repeated many times.

RE: T-sql

SQLRNNR — Fri, 17 Dec 2010 00:26:54 GMT

[quote][b]bitbucket-25253 (12/16/2010)[/b][hr]Trivial question[/quote]Agreed that it is straight forward.

RE: T-sql

bitbucket-25253 — Thu, 16 Dec 2010 21:03:33 GMT

Trivial question

T-sql

Rahul The Dba — Thu, 16 Dec 2010 21:02:37 GMT

Comments posted to this topic are about the item [B]T-sql[/B]