Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1011121314»»

Rowcount Expand / Collapse
Author
Message
Posted Monday, February 1, 2010 8:50 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:13 AM
Points: 1,051, Visits: 1,415
bitbucket-25253 (2/1/2010)


I think that the QOD has two equally valid values.
1. To allow individuals to test their knowledge.
2. To teach.

For those who know the answer it is a re-assuring experience
For those who do not know the answer, running the code teaches them something (at least I hope it does)


Nothing wrong with any of that, but for those who don't know the answer, should they be running the code before they answer, or after they have answered and got it wrong? I believe learning from mistakes is far better than not allowing yourself to make the mistake. It's not even so much people that do that as people that do it then bleat about it when the question is wrong that get me, and there were more than a handful going back through this thread admitting as much

'I ran the code and it said 1,1 so i chose that and it gave me the wrong answer and i'm not happy!'

Just doesn't seem right to me...
Post #857247
Posted Monday, February 1, 2010 10:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 6:20 AM
Points: 1,352, Visits: 1,312
bitbucket-25253 (2/1/2010)

What we do not know is how many answer incorrectly, and do NOT post a moan and groan, but DO LEARN something which in the future will be of benefit to them.

Let me guess: majority?

For me, discussion is many times very interesting and very fruitfull. This one made me to think about things a little more.
Thank god for such controverse QotDs, I learned a lot of them.




See, understand, learn, try, use efficient
© Dr.Plch
Post #857394
Posted Monday, February 1, 2010 10:46 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
paul.goldstraw (2/1/2010)
....
Nothing wrong with any of that, but for those who don't know the answer, should they be running the code before they answer, or after they have answered and got it wrong? I believe learning from mistakes is far better than not allowing yourself to make the mistake. It's not even so much people that do that as people that do it then bleat about it when the question is wrong that get me, and there were more than a handful going back through this thread admitting as much

'I ran the code and it said 1,1 so i chose that and it gave me the wrong answer and i'm not happy!'

Just doesn't seem right to me...


I knew the answer was (0, 1) because I still use QA for 2005 and for 2008. I still tested it because I like my points. Then I learned that the answer that I knew had some qualifications. Nothing wrong with that. This isn't a contest.


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #857406
Posted Thursday, February 4, 2010 3:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 28, 2010 7:35 AM
Points: 253, Visits: 40
First Time it gives 0,1
Then second time when we run query again it gives output 1,1
An d it must be 0,1
Post #859486
Posted Thursday, February 4, 2010 6:51 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 7,087, Visits: 6,894
bitbucket-25253 (2/1/2010)

I think that the QOD has two equally valid values.
1. To allow individuals to test their knowledge.
2. To teach.

For those who know the answer it is a re-assuring experience
For those who do not know the answer, running the code teaches them something (at least I hope it does)


Hear, Hear

I thought it was a sort of 'trick' question and so answered 0,1
Then I ran it to check and used QA on SQL2K it returned 0,1
Then I noticed the 2005/2008 reference, damn
Ran QA on 2005 and it returned 0,1
Mmmm, thinks....
Ran SSMS on 2005, returned 1,1
Ran SSMS on 2000, returned 0,1

So the moral is...
If 2005/2008 is mentioned use SSMS

But I'm not complaining, learned something, and so, is worth more than 1 point



Far away is close at hand in the images of elsewhere.

Anon.

Post #859618
Posted Thursday, February 4, 2010 4:29 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, June 21, 2014 6:12 AM
Points: 370, Visits: 715
Not sure what I'm learning from this.
Got 0, 1 when I first executed the 2 select lines in SSMS 2008 connecting to SQL Server 2005 - typed into a query window which had already executed some code.

Got 1,1 in the same setup and instance when I executed the 2 lines into a freshly opened query window.

Got 1, 1 when I first ran the 2 lines in a SSMS 2005 to SQL Server 2005.

Some people care about the percentage of right answers to QOD ...
Post #860040
Posted Tuesday, February 9, 2010 7:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 10:29 PM
Points: 25, Visits: 83
I've got (3, 1) becuase my latest query returned 3 rows.
Post #862898
Posted Thursday, February 11, 2010 8:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 11, 2010 8:15 AM
Points: 2, Visits: 1
I can see by the discussion thread that the answer was initially 0,1 - which was my answer. I got it wrong. The answer is now 1,1. I tested this on SQL 2000 and SQL 2005 using the same methodology. That is - I started query manger / management studio and did nothing else but run the query. SQL 2000 returned 0,1 SQL 2005 returned 1,1.
This was a good question but unfortunately it would have been excellent if the version of SQL were specified.
Post #864103
Posted Friday, March 12, 2010 5:55 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 15, 2014 5:07 PM
Points: 227, Visits: 192
Hi,

I ran this code in already opened SSMS windows and got 0,1 which is a wrong answer but later on I got 1,1...

Can't seem to understand why I got 0,1 in the first run? I'm sure the connection to the db was active not disconnected.


Razi, M.
http://questivity.com/it-training.html
Post #882215
Posted Friday, March 19, 2010 3:10 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 7:57 AM
Points: 2,697, Visits: 89
I got the different result sets in SQL 2005 and 2008. In 2005, I always getting output (1,1) whether it is a new (first) connection or new query window is open, but in case of SQL 2008, If it is new (first) connection then the output will be (1,1) but if it is new query window through the existing connection then it is (0,1)


Warm Regards,

Jignesh Mehta

Post #886162
« Prev Topic | Next Topic »

Add to briefcase «««1011121314»»

Permissions Expand / Collapse