May 6, 2009 at 1:16 pm
I noticed the sarcasm and I noticed the 'NULL'. I've just been bothered by the thread. If the question would be this don't work:
SELECT blah FROM anywhere
UNION ALL
SELECT 'NULL'
.. I would give an answer, but only "Try for me"...
I also already saw "NULL" in columns. Equal to the question "I didn't wrote anything into the column. Why does it show NULL?" :crazy:
May 6, 2009 at 1:19 pm
Bob Hovious (5/6/2009)
Thankfully, I have yet to see a column named [NULL].
Sorry, forgot: How often did you have a column "Group" or even "From" (and "To") 😀
May 6, 2009 at 1:25 pm
Florian Reischl (5/6/2009)
Bob Hovious (5/6/2009)
Thankfully, I have yet to see a column named [NULL].Sorry, forgot: How often did you have a column "Group" or even "From" (and "To") 😀
Yep. You can do just about anything. I thought this was pretty amusing.
http://www.simple-talk.com/community/blogs/rodney/archive/2008/12/08/70805.aspx
May 6, 2009 at 1:30 pm
😀
Just one thing missing:
DECLARE @t TABLE (Id INT, [*] VARCHAR(10))
INSERT INTO @t SELECT 1, 'abc'
SELECT [*] FROM @t
Hope The Thread forgives this kind of source code!
May 6, 2009 at 1:45 pm
Florian Reischl (5/6/2009)
😀Just one thing missing:
DECLARE @t TABLE (Id INT, [*] VARCHAR(10))INSERT INTO @t SELECT 1, 'abc'
SELECT [*] FROM @t
Hope The Thread forgives this kind of source code!
Bwaaaah, ha, ha. :laugh:
Amazing how fast the thread goes. I stopped to work for awhile and it takes forever to catch up.
Isn't great how you can do anything?
Oh, and I agree with Bob, I'd love it if everyone sounded like their Avatar. Of course that make Flo a tired and irritable Garfield.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 6, 2009 at 1:58 pm
Okay. I couldn't stop myself. Had to try it.
create table dbo.[Table] (
[Identity] int identity primary key,
[Column] varchar(100),
[*] int,
constraint [ForeignKey] foreign key ([*]) references dbo.[Table]([Identity]));
go
create index [Index] on dbo.[Table]([Column])
include ([*]);
Command(s) completed successfully.
- 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 6, 2009 at 1:58 pm
Bob Hovious (5/6/2009)
You always have the option to avert your eyes and let others assist him.They might give him bad advice though.
He might even take it.
BTW, if I ever get to meet you and/or Barry, I will be crushed if you don't sound like your avatars.
While I do have a low voice, I am no James Earl Jones. Mind you I could do a mediocre impression in my younger days, but I don't have that kind of vocal range/control anymore. 🙁
[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 6, 2009 at 2:00 pm
Oh, and I agree with Bob, I'd love it if everyone sounded like their Avatar. Of course that make Flo a tired and irritable Garfield.
Since I don't have an avatar, would that make me sound like Null?
Or should I go get an avatar of one hand clapping?
- 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 6, 2009 at 2:03 pm
If I sounded like my avatar, it would be some kind of klaxon/alarm bell/buzzer/siren/end-of-the world noises. 😀
By the way, I'm now having to deal with a table named dbo.[Plan].
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:04 pm
I sound just like my avatar....:hehe:
-Roy
May 6, 2009 at 2:06 pm
But do you look like your avatar, Roy?
P.S. It's good to see you back online. I can't remember if I said that earlier.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 6, 2009 at 2:06 pm
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth none the less.
Great. Now I have to go look up "avuncular" just so I can tell if Grant is really dissing me!
🙂
[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 6, 2009 at 2:09 pm
Roy Ernest (5/6/2009)
I sound just like my avatar....:hehe:
LOL!
- 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 6, 2009 at 2:10 pm
Bob Hovious (5/6/2009)
But do you look like your avatar, Roy?P.S. It's good to see you back online. I can't remember if I said that earlier.
Yes, I do look like my Avatar.. And Thanks for the welcome.. 🙂
Been back for a week now, but busy with work. Moving to a new server tonight. Have a slight HW issue with the present server. So doing a Warm StandBy Switch over tonight... 🙂
PS : I dont have the Indian accent though.... :hehe:
-Roy
May 6, 2009 at 2:12 pm
RBarryYoung (5/6/2009)
Grant Fritchey (5/6/2009)
Lynn Pettis (5/6/2009)
sorry, crushed you will be.I don't know. I met Barry at the PASS Summit last year. He sounded a bit like Darth... an avuncular friendly Darth, but Darth none the less.
Great. Now I have to go look up "avuncular" just so I can tell if Grant is really dissing me!
🙂
Oh great! I can just see the scene now: "No Grant! I am your uncle!" "Noooooooooooooo!"
- 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
Viewing 15 posts - 4,051 through 4,065 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply