Jan Van der Eecken

Forum Replies Created

Viewing 15 posts - 601 through 615 (of 667 total)

RE: Enhancing the readability of your code: Table aliasing in sql

lfallis (5/7/2009)
Each to their own again... I prefer proper case as personally I find it more readable. Keywords are highlighted differently anyway (working on the assumption that their aren't many...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 7, 2009 at 4:59 am

#990222
RE: Enhancing the readability of your code: Table aliasing in sql

David Hutcheson (5/7/2009)
What Jeff Moden said.
I totally agree with his point about leading commas. It might save you an error or two when you forget to delete it from...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 7, 2009 at 4:46 am

#990217
RE: Weird datetime conversions

I agree completely with you, Hugo. I hate implicit conversions because they lead to all kinds of problems while your code is in production. Conversions from varchars to datetimes to...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 7, 2009 at 3:53 am

#990201
RE: Weird datetime conversions

Apart from the formatting issue, what does it really mean if one adds two dates together? Yeah, I can see that adding today's date and tomorrow's date as in
SELECT GETDATE()+GETDATE()+1
yields
2118-09-12...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 7, 2009 at 2:16 am

#990177
RE: Are the posted questions getting worse?

Bruce W Cassidy (5/6/2009)
Jan Van der Eecken (5/6/2009)
What is DDL?
[font="Verdana"]It's a spray that you apply liberally to rid yourself of unwanted pests. :w00t:[/font]
You meant "Posts"?
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 6, 2009 at 2:51 pm

#989975
RE: Are the posted questions getting worse?

Bruce W Cassidy (5/6/2009)
[font="Verdana"]Does anyone remember a language called Algol? I believe that in the original form, it had no concept of "reserved words", so it was perfectly valid...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 6, 2009 at 2:49 pm

#989974
RE: Are the posted questions getting worse?

Flo, are you sure anyone can read that?
Me am happy and a Newbee, you know... So my question is
SELECT FROM FROM FROM WHERE FROM = FROM OR FROM = 'ItDepends'
This...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 6, 2009 at 2:30 pm

#989953
RE: Are the posted questions getting worse?

Florian Reischl (5/6/2009)
Alvin,
I have to confirm Bob. Because I am more a C#y than a VBly I would say "null" is always better than "Nothing"
BTW: In contrast to Bob I...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 6, 2009 at 2:12 pm

#989927
RE: before insert trigger equivalent

Just realized, I may have misunderstood you. Did you mean you need to know beforehand what the identity number will be that is assigned to the row you are about...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 5, 2009 at 2:31 pm

#989197
RE: before insert trigger equivalent

Hi Nagendra,
Why do you add your question to a thread that's been dead for more than six months? And then on a totally differemt topic?
Just to help you on the...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 5, 2009 at 2:24 pm

#989193
RE: Are the posted questions getting worse?

It snows here as well occasionally. Not down in town, but on the mountains surrounding Cape Town (occasionally some slush on Table Mountain too, but rarely). When it DOES snow,...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 5, 2009 at 1:53 pm

#989165
RE: Are the posted questions getting worse?

GilaMonster (5/5/2009)
Why would I ever trace a gorgeous African summer for that damp, slightly warm couple months that they call summer in the UK?
(before anyone gets offended, I'm originally from...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 5, 2009 at 1:37 pm

#989146
RE: Are the posted questions getting worse?

RBarryYoung (5/5/2009)
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... 🙂
He, why...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 5, 2009 at 1:30 pm

#989139
RE: Are the posted questions getting worse?

Sure, just gimme a shout when you are at the airport.
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 5, 2009 at 12:00 am

#988560
RE: Are the posted questions getting worse?

john.arnott (5/4/2009)
Zevon was a marvelous songwriter. I expected you, Gail, to maybe be familiar with "Roland the Headless Thompson Gunner" as it tells a story set on your continent,...
--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)
In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

May 4, 2009 at 3:43 pm

#988442

Viewing 15 posts - 601 through 615 (of 667 total)