Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by bitbucket
»
VIEWS 6
22 posts, Page 1 of 3
1
2
3
»
»»
VIEWS 6
Rate Topic
Display Mode
Topic Options
Author
Message
bitbucket-25253
bitbucket-25253
Posted Monday, April 09, 2012 8:08 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 5,123,
Visits: 20,370
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
baabhu
baabhu
Posted Monday, April 09, 2012 11:11 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 12:19 AM
Points: 1,118,
Visits: 985
Thanks for the easy question. It seems like you are very specialist in views.
Cheers !!!!!.
Post #1280605
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, April 10, 2012 12:36 AM
SSCrazy Eights
Group: General Forum Members
Last Login: 2 days ago @ 6:30 AM
Points: 9,410,
Visits: 6,495
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
Carlo Romagnano
Carlo Romagnano
Posted Tuesday, April 10, 2012 1:25 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 1:10 AM
Points: 1,998,
Visits: 1,866
I do not like this kind of EXTREMELY easy questions.
Post #1280645
kapfundestanley
kapfundestanley
Posted Tuesday, April 10, 2012 1:59 AM
Right there with Babe
Group: General Forum Members
Last Login: Monday, June 10, 2013 1:49 AM
Points: 781,
Visits: 1,050
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
Rich Weissler
Rich Weissler
Posted Tuesday, April 10, 2012 2:58 AM
SSCommitted
Group: General Forum Members
Last Login: Today @ 4:32 AM
Points: 1,584,
Visits: 798
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
bitbucket-25253
bitbucket-25253
Posted Tuesday, April 10, 2012 5:52 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 5,123,
Visits: 20,370
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
SandyD
SandyD
Posted Tuesday, April 10, 2012 6:56 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2013 6:30 AM
Points: 2,
Visits: 53
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
cfradenburg
cfradenburg
Posted Tuesday, April 10, 2012 6:59 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 10:51 AM
Points: 1,562,
Visits: 1,932
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
Thomas Abraham
Thomas Abraham
Posted Tuesday, April 10, 2012 7:13 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:11 AM
Points: 1,168,
Visits: 1,470
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.
Post #1280763
« Prev Topic
|
Next Topic »
22 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.