May 5, 2009 at 7:28 am
David Webb (5/4/2009)
I got $10 that says he deleted the table and believes he can recreate it from the views.
That was my first thought too. But schemabinding should prevent that, I think. (Now I have to go test that.)
Edit:
create table BindingTest (
ID int identity primary key,
Col1 varchar(10));
go
create view BindingTestView
with schemabinding
as
select ID, Col1
from dbo.BindingTest;
go
create unique clustered index IDX_BTest on dbo.BindingTestView (ID, Col1);
go
drop table dbo.BindingTest;
Msg 3729, Level 16, State 1, Line 1
Cannot DROP TABLE 'dbo.BindingTest' because it is being referenced by object 'BindingTestView'.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 7:35 am
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff, Pork Chops at the ready in both hands methinks :laugh:
Given the current situation with the swine flu, are we allowed to throw pork chops?
😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 5, 2009 at 7:37 am
RBarryYoung (5/4/2009)
Folks:I posted my first Microsoft CONNECT suggestion yesterday. It's suggestion #440375 entitled "Add Query-based bulk EXECUTE", you can find it here. Please support this suggestion by rating and/or voting for it.
Let me know what you think. Thanks.
I rated it important. Good suggestion.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 7:55 am
MarkusB (5/5/2009)
Ok, I stayed away from this thread so far and it looks like it's about a lot of other things not related to the quality of the questions but I can resist to point to this one:http://www.sqlservercentral.com/Forums/Topic710052-146-1.aspx
Yeah, that looks like a lost cause.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 7:59 am
Lynn Pettis (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Wow! I don't think I've seen that many significant errors in a script in a while. Incorrectly defined columns in the table DDL, two ON statements for identity insert, an extraneous Union All, and an attempt to insert duplicate values into a PK column.
Almost seems like something I would intentionally put into my tech-interview database. Or a classic, "How many things can you find that are wrong with this picture?"
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 7:59 am
Grant Fritchey (5/5/2009)
You're way too nice Lynn. I would've walked away. If I need people yelling at me when I'm trying to help, I can go home & help the kids with their homework.
I first read your reply while I was riding to school with my daughter and couldn't help but start to laugh.
Child - "But Dad, that isn't how they taught us to do that at school!"
Dad - "Did I get the right answer?"
Child - "Yes, but that isn't how they taught us how to do it!"
May 5, 2009 at 8:02 am
Paul White (5/5/2009)
Lynn Pettis (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.Are you sure he was shouting deliberately?
His posts seemed quite amiable up to that point, and he had already said that he had updated his post (in small letters).
Possible CAPS LOCK issue?
Possibly just trying to make sure the helpers in the thread noticed?
He is a newbie - so he may not even be aware that people take exception TO BEING SHOUTED AT!
Dunno - I'm just wondering...
Paul
I'm quite sure he was yelling at me. Look up from the post I linked and you'll see why I say that.
May 5, 2009 at 8:18 am
He was yelling.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 5, 2009 at 8:26 am
Child - "But Dad, that isn't how they taught us to do that at school!"
Dad - "Did I get the right answer?"
Child - "Yes, but that isn't how they taught us how to do it!"
And I even got told off once by my son's teacher for teaching him the wrong way to get the right answer :blink:
Far away is close at hand in the images of elsewhere.
Anon.
May 5, 2009 at 8:27 am
😀
Far away is close at hand in the images of elsewhere.
Anon.
May 5, 2009 at 8:31 am
Reaching the 4000 post...:-) Yea... Another round of celebration coming up soon
🙂
-Roy
May 5, 2009 at 8:35 am
Jan Van der Eecken (5/5/2009)
Sure, just gimme a shout when you are at the airport.
Heh. I so wish I could afford to follow through on this... 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 5, 2009 at 8:35 am
David Burrows (5/5/2009)
😀
Great post #4,000!! 🙂
May 5, 2009 at 8:36 am
Paul White (5/5/2009)
Darn it. I missed it by one day.My one chance this year to say to RBarryYoung: "May the 4th be with you"
:crying:
Yeah, even though someone gave the heads-up on this last week, we still all missed it yesterday. 🙁
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 5, 2009 at 8:37 am
David Burrows (5/5/2009)
Child - "But Dad, that isn't how they taught us to do that at school!"
Dad - "Did I get the right answer?"
Child - "Yes, but that isn't how they taught us how to do it!"
And I even got told off once by my son's teacher for teaching him the wrong way to get the right answer :blink:
I went in to talk to one of my kids teachers once because I couldn't help her with her homework because I couldn't do it the way she was teaching it (this was math) in class. I showed her what I was doing and getting the correct answer. She turned to my daughter, and in front of the class, stated quite clearly that there is more than one way to do it that works.
When it comes to math now, I don't get the argument above. But, I have also found something else that works. I have had my daughters show me how they are being taought to do things and I learn something but they, in many cases, have found their own errors in their homework. Turns into a win-win scenario.
Viewing 15 posts - 3,991 through 4,005 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply