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 123»»»

VIEWS 6 Expand / Collapse
Author
Message
Posted Monday, April 9, 2012 8:08 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Comments posted to this topic are about the item VIEWS 6

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1280565
Posted Monday, April 9, 2012 11:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 18, 2014 9:11 PM
Points: 1,302, Visits: 1,146
Thanks for the easy question. It seems like you are very specialist in views.

Cheers !!!!!.
Post #1280605
Posted Tuesday, April 10, 2012 12:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
Thanks for the question.
I was looking for a catch, but apparently there was none




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1280621
Posted Tuesday, April 10, 2012 1:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:49 AM
Points: 2,620, Visits: 2,467
I do not like this kind of EXTREMELY easy questions.
Post #1280645
Posted Tuesday, April 10, 2012 1:59 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: Tuesday, December 2, 2014 8:35 AM
Points: 968, Visits: 1,173
Easy one...like it,thank you.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
Post #1280655
Posted Tuesday, April 10, 2012 2:58 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 1, 2014 9:55 AM
Points: 1,823, Visits: 905
Koen Verbeeck (4/10/2012)
I was looking for a catch, but apparently there was none

This ^.^ Glad there is no one awake around here at this hour. I'm sitting here talking to myself outloud, "No! But what am I not getting?!? No, It wouldn't make any sense!" I was gonna be very disappointed if it didn't work the way I was sure it was suppose to. Thanks!
Post #1280674
Posted Tuesday, April 10, 2012 5:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
Not as easy as I thought it would be:

Correct answers: 75% (272)
Incorrect answers: 25% (91)
Total attempts: 363



Since one of the major objectives of the QOD is to teach I guess some 91 people learned something new, or just maybe have not had their morning cup of coffee.

And the last of my questions concerning VIEWS is currently scheduled for May 8th.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1280717
Posted Tuesday, April 10, 2012 6:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 10:50 AM
Points: 2, Visits: 72
I think the higher than expected number of incorrect answers may be due to people finding the question a little unclear. Here is another way of phrasing what I am guessing was intended:

Is the value for Col2 updated in the row where the value of Id =1 ?

As the question was written, "where the value of Id =1 updated" implies that the value of Id = 1 somehow updated as part of the update statement. I'm not sure that's what was intended.
Post #1280749
Posted Tuesday, April 10, 2012 6:59 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, December 18, 2014 10:51 AM
Points: 1,639, Visits: 1,986
I should have gone back and double checked. I assumed it was just asking about a view updating the underlying table, not about the update violating the column constraints. So that's one incorrect answer due to poor reading.
Post #1280752
Posted Tuesday, April 10, 2012 7:13 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:43 AM
Points: 1,925, Visits: 2,205
bitbucket-25253 (4/10/2012)
Not as easy as I thought it would be:

Correct answers: 75% (272)
Incorrect answers: 25% (91)
Total attempts: 363



Since one of the major objectives of the QOD is to teach I guess some 91 people learned something new...


Probably more than that, as some people who didn't know the answer likely guessed right.

Thanks for the question!


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1280763
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse